Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic

Re: Big database queries

by lhoward (Vicar)
on Aug 30, 2002 at 00:52 UTC ( #193961=note: print w/replies, xml ) Need Help??

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. ;)

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://193961]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (5)
As of 2021-03-05 01:48 GMT
Find Nodes?
    Voting Booth?
    My favorite kind of desktop background is:

    Results (108 votes). Check out past polls.