Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris

Re: Re: DBI/mysql gathering all rows on execute

by sgifford (Prior)
on Nov 24, 2003 at 21:17 UTC ( [id://309693]=note: print w/replies, xml ) Need Help??

in reply to Re: DBI/mysql gathering all rows on execute
in thread DBI/mysql gathering all rows on execute

Thanks, it was $sth->{"mysql_use_result"} = 1; that I needed!

The right indexes are all in place (and EXPLAIN SELECT agrees), there are just a huge number of rows in the result set.

Now here's the other weird thing, which doesn't matter for my real project but is still unusual. When I make this change, the test program I posted above works better, but now it hangs for a long time during the finish. That surprises me; I would expect it to cancel the query and return immediately. Anybody know what's going on?

Log In?

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

How do I use this?Last hourOther CB clients
Other Users?
Others scrutinizing the Monastery: (4)
As of 2024-05-30 16:52 GMT
Find Nodes?
    Voting Booth?

    No recent polls found