Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
PerlMonks  

Re: Determining if a DBI SELECT comes back empty

by Zed_Lopez (Chaplain)
on Dec 05, 2003 at 21:03 UTC ( #312639=note: print w/replies, xml ) Need Help??


in reply to Determining if a DBI SELECT comes back empty

I think I don't understand. If you need the results for further processing when there are results, where's the memory penalty? When there are no results, you have an empty array, which involves trivial memory, and you move on.

You could do SELECT COUNT(*)'s in advance, but that does incur a performance penalty over what you're already doing.

  • Comment on Re: Determining if a DBI SELECT comes back empty

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (4)
As of 2020-01-23 23:01 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Notices?