Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

Re: Re: Re: Re: fethrow_array return value

by runrig (Abbot)
on Jan 10, 2004 at 02:13 UTC ( #320274=note: print w/replies, xml ) Need Help??


in reply to Re: Re: Re: fethrow_array return value
in thread fetchrow_array return value

and the fastest too.

Perhaps the most intuitive, but not necessarily the fastest (update: the fastest way to determine if there are any rows, that is, as the OP asked for). If your database is able to return rows as they're found (i.e. it doesn't have to return the entire result set like MySQL), and if there are any rows, it can be faster to do a select 1 from table... than to do a select count(*) from table....

Replies are listed 'Best First'.
Re: Re: Re: Re: Re: fethrow_array return value
by Roger (Parson) on Jan 10, 2004 at 03:05 UTC
    I meant the fastest way to determine the number of rows though.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (3)
As of 2019-08-21 22:15 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?