[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 208
  • Last Modified:

too slow

hi,

I am using perl dbi to connect to mysql and get the number of rows of a table using the following code:

$sql2=qq{select * from tutorf};
$sth2=$DBH->prepare($sql2);
$sth2->execute();
$row2=$sth2->rows();
$sth2->finish;

there is total 8000 rows in the table.
The problem is the speed of this code is very slow!!!

any method i can speed up it?
0
klnhk
Asked:
klnhk
1 Solution
 
ddaCommented:
'select count(*) from table' will go.
0
 
inq123Commented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

Accept a comment by dda

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

inq123
EE Cleanup Volunteer
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now