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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]