Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number

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 all is quiet...

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (4)
As of 2018-03-24 22:28 GMT
Find Nodes?
    Voting Booth?
    When I think of a mole I think of:

    Results (299 votes). Check out past polls.