Re: Perl DBI - How to handle large resultsets?

stone wrote:

> Hey, tnx for the reply.
>
> I'm pretty sure i'm getting these errors because of the large result
> set because I have 6 other identical functions which work but only
> return a couple of dozen rows. In this particular case its in the
> 10's of thousands.
>
> I've commented out the functions that return the large result sets and
> the program runs without error.
>
> And Opps.. I missed the declare of repo_sth in that function.


I doubt the size of the result set is your problem. The DBI module is quite
mature. I have a app that returns 10's of thousands of rows per execution,
and it gets hit thousands of times a day. In the extreme I've run queries
that have returned millions of rows and DBI has never choked on me.


--
Brian Wakem

.