Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw
 
PerlMonks  

Re: Determining if a DBI SELECT comes back empty

by Zed_Lopez (Chaplain)
on Dec 05, 2003 at 21:03 UTC ( [id://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
Domain Nodelet?
Node Status?
node history
Node Type: note [id://312639]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others studying the Monastery: (4)
As of 2024-04-24 01:17 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found