Hi gString,
As your original tech support question is now answered I’m going to move this post down to the Community Help forums as your other questions are more related to how to work in ExpressionEngine and best practices.
That said I’ll answer the questions as far as I can :
1. About DB access: Is there detailed and through guidelines somewhere, that I can read?
Nothing really concrete in respect to that but just ensure that you have really good use of the disable=”“ parameter wherever you can and try to use as few tags on the page as you can. Utilising the Admin > System Administration > Output and Debugging Preferences > Display Output Profiler option can help a lot of the time enabling you to see where large jumps of processing time happen on your template / page and so can help you fault find on your own a lot of the time.
BTW, I am aware of the “disable” feature. It is pity that you don’t have “enable” feature that would save a lot of typing in some cases.
Please feel free to add a Feature Request for that if you want.
2. About my local variable: think about the page I’m working here. I have to request the same entry a few times in that template. If I could have a way to set a local object or array that I can get all the data into it once (one DB access) and when use it over and over to my heart content - that would be awesome. Such a thing would be useful in many cases, IMHO. You don’t have that option, by chance?
There isn’t anything like that built in to ExpressionEngine but there are a few 3rd party add-ons which allow you to take information from say one Channel Entries tag and then re-utilise it on your page multiple times without having to place another Channel Entries tag in there again.
There is one that I know of here - MX Jumper and I’m sure there are more on http://devot-ee.com if you perform a search over there.
Hope that helps a bit.
Thanks,
Mark