Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things

Re^2: fetch row or fetchall

by steves (Curate)
on Nov 10, 2004 at 13:37 UTC ( #406671=note: print w/replies, xml ) Need Help??

in reply to Re: fetch row or fetchall
in thread fetch row or fetchall

Note that the DBI RowCacheSize database handle attribute can often help you balance your memory/speed tradeoff for large queries. But it depends on the underlying database -- not all can make use of it. In practice, I have found some significant differences in query time/memory when changing this for queries that return large numbers of rows.

For significant database applications I find it nearly impossible to write SQL that works across all. I always end up having to make use of database-specific functions or other constructs. If your application is only going to run on one database it's probably fine to make use of LIMIT, TOP, or Oracle's ROWNUM. It depends on whether your priority is speed and function or portability across databases.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://406671]
and one hand claps...

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (2)
As of 2018-02-19 06:24 GMT
Find Nodes?
    Voting Booth?
    When it is dark outside I am happiest to see ...

    Results (258 votes). Check out past polls.