Re: storing query result in arrays: waste of memory?
| From: | (Stas Trefilov) | Date: | Sun, 28 Jan 2001 11:31:52 +0000 |
| Subject: | Re: storing query result in arrays: waste of memory? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-6281@lists.php.net to get a copy of this message | ||
Hello, "Tyson Lloyd Thwaites"!
You wrote:
> Is it better to retrieve the whole table up-front and
> store it in a session
> array, or to run the queries seperately each time the
> data is needed and
> specify the column targets?
>
First read all the short columns from the row in your base
class constructor (or get(), or whatever) and the rowID of
the record, to minimize access time when you need CLOB
content. Don't cache CLOBs.
--
Piloteers do it on the road