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 aconsiderable performance benefit, or is it just more or less another way todo 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.
PGP.sig
Description: This is a digitally signed message part