PhotoPost Community - View Single Post

DST Daddy · January 5th, 2007, 08:54 AM

I finally got around to updating photopost, am now running 5.62.

several queries run VERY regularly which a month ago only had to sort through 240,000 records, now the queries sort through 300,000 records.

doing a "show full processlist" on my mysql server I find 4 instances of this query

"SELECT username,id,date,photo FROM pp_comments ORDER BY date DESC"

which selected 305,773 records and sorts them by date (a field without an index)...

another query which comes up quite regularly is "SELECT id,user,userid,date FROM pp_photos ORDER BY date DESC" or a variation which looks similar to "SELECT id,user,userid,date FROM pp_photos ORDER BY date DESC" these queries sort through 50,000 + records each, again on date... which is not in indexed field.

what should the next step be? (we are working on getting things broken down into multiple categories)

January 5th, 2007, 08:54 AM	#14 (permalink)
DST Daddy Member Verified Customer Join Date: Aug 2006 Posts: 63	I finally got around to updating photopost, am now running 5.62. several queries run VERY regularly which a month ago only had to sort through 240,000 records, now the queries sort through 300,000 records. doing a "show full processlist" on my mysql server I find 4 instances of this query "SELECT username,id,date,photo FROM pp_comments ORDER BY date DESC" which selected 305,773 records and sorts them by date (a field without an index)... another query which comes up quite regularly is "SELECT id,user,userid,date FROM pp_photos ORDER BY date DESC" or a variation which looks similar to "SELECT id,user,userid,date FROM pp_photos ORDER BY date DESC" these queries sort through 50,000 + records each, again on date... which is not in indexed field. what should the next step be? (we are working on getting things broken down into multiple categories)