I just migrated a store with around 5.000 products, i always found the store a bit slow (around 4/5s per page), this was a year back 2s. so it slowly declined.
I now installed a complete new server with loads of ram, ssd disks and so on. this did not improve a single. this. This site is the only site running on this server.
When i run the top command, i see the following
p 2 days, 20:39, 2 users, load atotop - 11:52:44 utop - 11:53:09 up 2 days, 20:40, 2 users, load average: 1.80, 1.91, 1.99 Tasks: 242 total, 4 running, 237 sleeping, 0 stopped, 1 zombie Cpu(s): 55.3%us, 5.1%sy, 0.0%ni, 37.9%id, 1.6%wa, 0.0%hi, 0.0%si, 0.0%st Mem: 32695208k total, 31576368k used, 1118840k free, 359384k buffers Swap: 16777084k total, 8492k used, 16768592k free, 29262460k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 10276 mysql 20 0 1332m 66m 6984 S 233.7 0.2 49:16.61 mysqld
This seems to be the real issue of the lack of speed. even with things like redis no improvement off all, so finding cache solutions is the wrong way i suspect.
it definitely needs to be database health kind of thing. i mean i have store running on poorer servers with 2 to 8 times more products without issues.
I have no clue where to look for anymore.