Tim Bunce wrote: > Just to be clear on this: The *DBI driver* does not do that. > > For MySQL the underlying db client library does that by default. > (I think that's also true for Postgres.) Oracle client libs default to > prefetching one extra row but DBD::Oracle tells it to prefetch about two > ethernet packets worth.
Apologies, Tim. My DBD::Oracle expertise is out-of-date. I remember needing to fiddle with the prefetch settings to deal with large result sets at etoys.com, but that was some 8 years ago and we might well have created that problem ourselves through our attempts to improve the common case of small queries. - Perrin ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Rose-db-object mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/rose-db-object
