I just posted this question to Stack Overflow and figured I’d try asking here as well.
I’ve optimized a complex template to the best of my knowledge, and I’m still looking to get rendering time under 1 second, whether I need to make application-level adjustments or server-level adjustments.
The page in question is grid of 195 projects, each with several Playa relationships (client, vendor, office, etc.) that are actually displayed and filterable.
uncached: 16.0904 seconds, 50.11MB, 5264 queries
after application-level caching: 2.0793 seconds, 28.37MB, 476 queries
The drop is largely a result of EE’s template caching, tag caching, and channel “disable” parameters per the EE Wiki Optimization article.
This is all happening on a MediaTemple DV4 server with 512MB of memory, which I imagine will get destroyed at this rate. Production site traffic is ~4K pageviews per day.
The only idea I’ve had so far is to load only featured items and save the (larger, initially hidden) chunk of content asynchronously. The only reason I don’t like that idea is the potential ding for SEO. Each project has a detail page, so it may not be an issue, but it seems like this is all useful information to have indexed.
Are there any safe ways, without hacking ExpressionEngine’s core, to drop my minimum page rendering time to less than a second? Have I simply set myself up to fail?