|
|
Posted by Peter Fox on 11/15/05 03:06
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
peterfox@eminent.demon.co.uk.not.this.bit.no.html
2 Tees Close, Witham, Essex.
Gravity beer in Essex <http://www.eminent.demon.co.uk>
Navigation:
[Reply to this message]
|