Following on from Dave Smithz's message. . .
Firstly
Mysql will let you retrieve a bit at a time. Something like LIMIT -
RTFM SELECT syntax. This will open other options for getting results.
Secondly
Are you properly disposing of previous large result sets as a matter of
course. ISTR that PHP does GC at end of script by default and possibly
sql allocations cascade later from these.
Thirdly
PRUNE! Any user who can interpret 16Mb of data doesn't need a database
- they have a brain the size of a planet anyway!. (Possibly cut out
blobs from the query and retrieve a bit at a time.?)
Hi there,
I changed one of my MySQL search queries to allow a situation where the user
gets much more information returned.
However, it has now given me the error message:
Fatal error: Allowed memory size of 16777216 bytes exhausted (tried to
allocate 42 bytes) in /usr/share/pear/DB/mysql.php on line 290
OK I understand what this means (I assume) that the program is trying to
allocate more memory to return my query result but it wont let it.
However, I need this query to return this info, so what can I do?
Any help / explanations appreciated.
Kind regards
Dave.
--
PETER FOX Not the same since the bridge building business collapsed
pe******@eminent.demon.co.uk.not.this.bit.no.html
2 Tees Close, Witham, Essex.
Gravity beer in Essex <http://www.eminent.demon.co.uk>