PhotoPost Community - View Single Post

DST Daddy · January 5th, 2007, 10:34 AM

Thanks... I will look into it...

I have turned on the slow queries log in mysql, and am seeing lots of queries returning over 50k records and over 290k records

I know that there are not any pages which show 50k records or 290k records on them..... can't these queries be limited to return a smaller record set? Most of what is being returned is being disregarded by php anyway.

January 5th, 2007, 10:34 AM	#18 (permalink)
DST Daddy Member Verified Customer Join Date: Aug 2006 Posts: 63	Thanks... I will look into it... I have turned on the slow queries log in mysql, and am seeing lots of queries returning over 50k records and over 290k records I know that there are not any pages which show 50k records or 290k records on them..... can't these queries be limited to return a smaller record set? Most of what is being returned is being disregarded by php anyway.