On Wed, 17 Aug 2005 14:36:01 +0200, Steffen Goeldner <[EMAIL PROTECTED]> wrote:
> H.Merijn Brand wrote: > > > The docs could use an example, and it only works if you fetch all the > > data in advance. > > Yes, the result set has to be completely materialized on the client > before it can be fetched via DBD::Sponge. A few months ago I did some > experiments to avoid this: > > <http://www.xray.mpe.mpg.de/mailing-lists/dbi/2005-03/msg00144.html> > <http://www.xray.mpe.mpg.de/mailing-lists/dbi/2005-03/msg00217.html> Right. Good reading. I most probably skipped it then, because I didn't have the faintest idea what DBD::Sponge was and thus decided it was not interesting for me. In case of my use for foreign_key_info (), the set will only be big in case all arguments are undef, and there are quite a few links in the database, but I never expect it to be huge. BTW Nice link about that Dutch database: http://monetdb.cwi.nl/ Looks quite promising. How does it's performance and functionality compare to Progresql? -- H.Merijn Brand Amsterdam Perl Mongers (http://amsterdam.pm.org/) using Perl 5.6.2, 5.8.0, 5.8.5, & 5.9.2 on HP-UX 10.20, 11.00 & 11.11, AIX 4.3 & 5.2, SuSE 9.2 & 9.3, and Cygwin. http://www.cmve.net/~merijn Smoking perl: http://www.test-smoke.org, perl QA: http://qa.perl.org reports to: [EMAIL PROTECTED], [email protected]
