Comment to The need for speed
-
1000's of queries? Why?
Exactly which UNA page were you refering to? Home page? Discussions?
-
tmp tables size can be increased more, depending on your RAM availability.
what is paginate number in discussions ? also some blocks can be loaded asynchronously, especially the blocks which are outside of the initial screen, so the page will load quickly and then some blocks will be loaded after page is loaded, you can set it in page block params - "Asynchronous Mode":
-
- Doubled the tmp parameters for MySQL - Unchanged performance.
- Paginate number in discussions - This is the number of rows in terms of the number of displayed discussions on the page. One previous poster was suggesting decreasing this value - but 12 is reasonable. (Context discussions-home page)
- Async mode? Its a useful way to "hide" the problem. Underlying logic and/or queries still need optimisation. Fixing this will greatly help the user experience of Una, more than anything else. I set that mode for the popular discussions. Helpful, but not a silver bullet.
-
One more idea, could you please try to switch to file based cache instead of Memcached ? to see if it makes any difference