Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

Re: DBI placeholders less efficient?

by cfreak (Chaplain)
on Mar 08, 2005 at 17:34 UTC ( [id://437671]=note: print w/replies, xml ) Need Help??


in reply to DBI placeholders less efficient?

It doesn't look like you're using the value of $i in either of your loops, instead some arbitrary variables that were set elsewhere. If this is your real query then you don't need a loop at all, in fact your select statement would return the same row every time if you actually fetched from it. If you're trying to get 800 results then use one query with LIMIT

If this is just an example then I think we need more info on what you're trying to accomplish.

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others pondering the Monastery: (2)
As of 2024-04-25 02:09 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found