RE: count(*) questions

2001-04-26 Thread Braxton Robbason
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Cindy Sent: Thursday, April 26, 2001 4:02 PM To: [EMAIL PROTECTED] Subject: count(*) questions OK, I have a perl script using mysql that pulls up a bunch of numbers for a table. Problem is it's taking a long time because of the numbe

count(*) questions

2001-04-26 Thread Cindy
OK, I have a perl script using mysql that pulls up a bunch of numbers for a table. Problem is it's taking a long time because of the number of select calls I'm making. Basically, I have a sequence of calls of the form: SELECT COUNT(*) FROM WHERE (execute, get value of count, print out as cel