Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?

Re: DBD::SQLite dilemma

by liz (Monsignor)
on Aug 11, 2003 at 10:18 UTC ( #282811=note: print w/replies, xml ) Need Help??

in reply to DBD::SQLite dilemma

4. do something special if $dbh->do is called in non-void context.

If called in void context, keep the current iterator way. If called in a non-void context, fetch all the records in memory and return number of records fetched.

Document that calling $dbh->do in non-void context will load all records in memory.

This should keep the old behaviour (which was loading all records already) and provide a new, compatible way of fetching records that uses less memory.


Another idea: recreate the query using COUNT() instead of the selected fields if $dbh->do is called in non-void context. Return the result of that query as the number of records. This would allow you to keep the current memory friendly behavior even when the number of records is requested. The risk of course is that the number of records is incorrect because of database updates between the SELECT COUNT() and the original SELECT.

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others scrutinizing the Monastery: (3)
As of 2020-11-30 02:58 GMT
Find Nodes?
    Voting Booth?

    No recent polls found