On Nov 20, 2008, at 4:15 AM, Rod Treweek wrote:

Hi Timo,

Thanks Timo. This is great. I followed your instructions, and sure enough,
everything is working as expected now.  Thank you very very much.  One
question I have,  What's the advantage of using prefetch?  Is this a
considerable performance benefit, or is it just more or less another way to
do things?  Thanks again.

With prefetch you're doing a single SQL query. Without prefetch you're doing two. If your SQL server isn't loaded, I doubt it helps much.

Attachment: PGP.sig
Description: This is a digitally signed message part

Reply via email to