This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.
The active forums are here.
April 14, 2010 5:36pm
Subscribe [7]#16 / Apr 14, 2010 10:03pm
In regards to number of queries; I have seen on this forum people that have written a *single* monstrous query that kills the server. By comparison, 30-60 well honed, sane queries will not have that much impact.
It’s quality, not just quantity. Both do play into it, of course.
#17 / Apr 14, 2010 10:04pm
Ok good to know Lisa. We’ll be using 1.6.x for some time (until all our precious third-party modules have been converted over to 2.0).
#18 / Apr 15, 2010 2:01am
In regards to number of queries; I have seen on this forum people that have written a *single* monstrous query that kills the server. By comparison, 30-60 well honed, sane queries will not have that much impact.
It’s quality, not just quantity. Both do play into it, of course.
Indeed, I didn’t mean to overstate query counting as a means of performance optimization… The number that is really important to us is page load.
In the context of the conversation, however, I believe that Joe was mainly looking for the most efficient way to break templates up into reusable pieces. Embedded templates are snappy, no doubt - but if you are looking at ways to squeeze a little extra performance out of your site then cutting out some unnecessary queries is an ok place to start.
#19 / Apr 15, 2010 6:44am
Limiting the queries is the main thing, especially with disable used effectively. Not knowing much about the actual templates / sub templates it is hard to say - if you only had 2-3 templates, then pull the menus into each and ignore embeds - clearly you have more, and hence why your doing this though.
I love all this talk of the wonderful EE2.0 being more helpful and better. But who does this really help, it is still in BETA (not intended for public commercial use yet), there are still a huge amount of extensions that need to be converted, and lets be honest the lack of news on this subject is draining. 2 months since the last update on progress, 4 months since BETA came out! i have to admit i went from believing the “its done when it is ready” approach to finding this whole thing annoying now….
Sorry side tracked…back to topic