Re: Perl and Oracle

Mladen Gogala <gogala_at_sbcglobal.net> wrote:
> On Sun, 09 Apr 2006 18:18:56 -0700, krichine wrote:
>
> >
> > specifically
> > http://search.cpan.org/src/TIMB/DBI_AdvancedTalk_2004/sld017.htm
> >
> > gives an example of how to use array bulk fetches.
>

..
> In addition to that, I used to work with a table which had 933 million
> rows and spanned more then 100GB. It was a table that contains claims for
> a large national HMO in US. I think that any "fetchall" call on that
> table would be an extremely interesting proposition, even if it went only
> after the partition containing the data for the last quarter. I wish you
> good luck with "fetchall" calls if you ever encounter such a monster. I
> believe though that few guys on this group are working with monsters of
> that magnitude or bigger on a daily basis.

Did you read ahead 2 slides? fetchall with $max_rows?

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB