| trackpads | November 2nd, 2012 09:30 PM |
Slow Queries
Chuck;
Probably to do with the size of the gallery but I am going to attach some slow queries and see if you think there is a way to impove them. Like do I need to an an index and which one if you think that would help. Not speaking about the pp query itself, just my site. Quote:
# Time: 121102 22:26:26
# User@Host: members_prime[members_prime] @ localhost []
# Query_time: 2.110317 Lock_time: 0.000014 Rows_sent: 1 Rows_examined: 518043
use members_prime;
SET timestamp=1351909586;
SELECT exifinfo FROM pp_exif WHERE photoid=17868;
| Quote:
# Time: 121102 22:26:35
# User@Host: members_prime[members_prime] @ localhost []
# Query_time: 0.737828 Lock_time: 0.000026 Rows_sent: 37 Rows_examined: 815832
SET timestamp=1351909595;
SELECT id,user,userid,cat,storecat,title,ismature,bigimage,height,width FROM pp_photos WHERE approved=1 AND storecat=0 ORDER BY date DESC LIMIT 37;
| Quote:
# Time: 121102 22:26:37
# User@Host: members_prime[members_prime] @ localhost []
# Query_time: 2.002131 Lock_time: 0.000098 Rows_sent: 37 Rows_examined: 1631611
SET timestamp=1351909597;
SELECT id,user,userid,cat,storecat,title,ismature,bigimage,height,width, id*0+RAND() as rand_col FROM pp_photos WHERE approved=1 ORDER BY rand_col DESC LIMIT 37;
| Quote:
# Time: 121102 22:27:17
# User@Host: members_prime[members_prime] @ localhost []
# Query_time: 2.016908 Lock_time: 0.000053 Rows_sent: 1 Rows_examined: 518043
SET timestamp=1351909637;
SELECT exifinfo FROM pp_exif WHERE photoid=774451;
| Quote:
# Time: 121102 22:37:03
# User@Host: members_prime[members_prime] @ localhost []
# Query_time: 0.800466 Lock_time: 0.000041 Rows_sent: 52619 Rows_examined: 105238
SET timestamp=1351910223;
SELECT id,user,userid,cat,storecat,date,title,description,ismature,keywords,bigimage,width,height,filesize,views,medwidth,medheight,medsize,approved,rating,votes,allowprint,numcom,lastposter FROM pp_photos WHERE cat=716 AND approved < 2 ORDER BY disporder,lastpost DESC;
| |
