in reply to Big database queries

if you need to process a lot of data its going to put a lot of load on the server no matter what you do. If you want to lower the aparent load on the servers (at the expense of your query taking longer) you can use sleep (with Time::HiRes you can sleep for a partial second). One thing you can do to improve performance on your side is to use fetchrow_arrayref instead of fetchrow_array. That will at least cut down on one string copy...

Replies are listed 'Best First'.
Re^2: Big database queries
by Flexx (Pilgrim) on Aug 30, 2002 at 08:52 UTC
    which will be 60 million string copies in our case... And I guess that'll make a difference. I once benchmarked fetchrow_array vs. fetchrow_arrayref in a CGI fetching some 50.000 rows, without any noticable difference, but at 60.000.000 rows that's another story. ;)