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]

Reply via email to