[eluser]Daniel H[/eluser]
What is the rule of thumb when it comes to caching very large results sets? With caching on, and selecting an entire table of c. 40000 records I get....
Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 445 bytes) in .../system/database/drivers/mysql/mysql_result.php on line 162
I can obviously increase the memory limit but I'm not sure what should be the maximum I should ever set it to.
Obviously I would never need to query the full 40000 records, but I'm just curious as to the max limit you'd need to use should be...
Thanks.