Gnub Posted April 16, 2007 Share Posted April 16, 2007 Ok, it's been a while since i've implemented Pagination into my queries. I've noticed that on large queries, the result will throw an error at me: Warning: mysql_query() [function.mysql-query]: Unable to save result set in ... on line 100 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in ... on line 101 Error: Lost connection to MySQL server during query Now, i have a backed up version of the same query, using the same pagination, but with the results set at 25 per page, compared to the 5 per page on the error, it does not get this error when the same query is sent. The table consists of on average of 40K records. I've done a little research, and i've found that there might be something wrong with the database, as in it might need repairing. But surely if it works for 1, but not the other, then theres nothing wrong with the db. Thoughts? Link to comment https://forums.phpfreaks.com/topic/47276-quetion-query-result-too-large/ Share on other sites More sharing options...
boo_lolly Posted April 16, 2007 Share Posted April 16, 2007 i think you should post some code. Link to comment https://forums.phpfreaks.com/topic/47276-quetion-query-result-too-large/#findComment-230619 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.