8

What you're doing isn't really the way to use media queries. Why is the 'data' (from which I read 'content') different based on the user agent? Is it actually different content or are you simply talking about layout? I would say your options here are; Output everything once and use CSS Media Queries properly to reformat the content appropriately for the ...


5

Most of required indexes are already there. What I usually do, is if I use custom sorting order with exp:channel:entries I add key on field that I sort by. I.e. if I have {exp:channel:entries orderby="title"} I add index on title in exp_channel_titles table. If I have {exp:channel:entries orderby="my_custom_field"} and my_custom_field is a custom field ...


3

For custom field columns that will be used in join statements I find its best to set the column type to an int or a varchar(#) and then index it as suggested. You can also optimise the way EE gets its data from the database. When EE queries the database for a set of channel entries it brings back a lot of data that is often not needed. This includes ...


3

I'm not aware of any established best practices for adding indexes to DB tables. I'd say the official EllisLab stance is you shouldn't have to add any because they've done this work for you where needed. But every project has different needs and developers have to evaluate this on a case by case basis depending on the project. In my years with EE, I've only ...


3

I personally think the ideal is that each page is cached non-stop until the content or template changes. This is possible with add-ons like Causing Effect CE Cache, which is great for high-performance / high-load sites. On these sites, pages can be cached for days and months without being refreshed. When I use only the built-in EE caching, I tend to set the ...


1

My understanding is, basically, no but it should not matter too much. You can remove/uninstall the Members module but it does not actually remove most of the member related tables and it doesn't control most of the queries which are sprinkled throughout core code and do not appear to be controlled by any global setting. You also cannot disable sessions in ...


1

It's been long enough now that I don't remember the details, but I had a conversation with Nevin of Engine Hosting and his recommendation was 10 minutes max. Maybe a conversation with someone from your hosting environment is in order.


1

I'd grab a copy of the EE Debug Toolbar and install it: http://devot-ee.com/add-ons/ee-debug-toolbar It adds a better interface for EE's template debugging, including a graph to plot the performance & time of each page render. Look for all the places where the processing time jumps. If you have a number of {embed=} tags, particularly within a loop of ...


1

That's a lot of entries to load for sure. I've done something like this once before with map data, but the solution may be the same for you. Assuming that your template is as optimized as it's going to get, you may need to cache and retrieve the "all" list in chunks - that's what I had to do for my map data. I did it using Solspace Template Morsels. It ...


Only top voted, non community-wiki answers of a minimum length are eligible