Re: Number of elements in array

by NetWallah (Canon)

on Sep 24, 2012 at 13:55 UTC ( [id://995388]=note: print w/replies, xml )

Need Help??

If you want to get the number of rows in a database table, the most efficient way would be to let the database count them:

  ...prepare ("Select COUNT(*) FROM TABLE_OR_QUERY");
   # TABLE_OR_QUERY can be another (SELECT...) statement
[download]

Most databases will optimize queries, so you can do the count query, then do the data query as 2 separate queries.

I hope life isn't a big joke, because I don't get it.
-SNL

Comment on Re: Number of elements in array Download Code

Replies are listed 'Best First'.
Re^2: Number of elements in array by tobyink (Canon) on Sep 24, 2012 at 14:03 UTC
This counts the number of rows. The OP was counting the number of columns. Of course, it's possible that the OP did actually want the number of rows... `perl -E'sub Monkey::do{say$_,for@_,do{($monkey=[caller(0)]->[3])=~s{::}{ }and$monkey}}"Monkey say"->Monkey::do'`	[reply]

Domain Nodelet^?

Node Status^?

node history
Node Type: note [id://995388]
help

Chatterbox^?

How do I use this? • Last hour • Other CB clients

Other Users^?

Others imbibing at the Monastery: (6)

As of 2024-04-23 08:29 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Voting Booth^?

No recent polls found