|
You can try 5.5 but I think your server has some part in any slow queries
I did those same queries on a site that has roughly the same size database photos comments and I get these times
1. Showing rows 0 - 5 (6 total, Query took 0.0089 sec)
2. Showing rows 0 - 0 (1 total, Query took 0.0012 sec)
3. Showing rows 0 - 29 (337 total, Query took 0.0038 sec)
4. Showing rows 0 - 0 (1 total, Query took 0.0008 sec)
5. Showing rows 0 - 20 (21 total, Query took 0.0016 sec)
Now take note query timing varies and we will depend on other factors like how many cats you have photos comments etc etc
First thing I would suggest you do is REPAIR and OPTIMIZE your database
|