I have a pretty plain vanilla LAMP install on a brand new EC2 server with 2 cores, 4GB of RAM, and 100GB SSD storage. Giving it more power than usual to see if that makes any difference in terms of page load time, but so far, not much!
I’m talking specifically about what I believe is the “advanced search” queries.
Anything from filtering a document type:
A sort within browse items:
Do you have a sense of whether the speed is primarily constrained by processor or RAM? Are there any easy/obvious/potential MySQL service changes in terms of database configuration tuning that would help? Bigger buffers? Bigger temp tables?