20 Nov
2008
20 Nov
'08
12:07 p.m.
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.