Solved

How to benchmark mysql databse performance using Perl DBI?

Posted on 2004-09-29
1
332 Views
Last Modified: 2012-05-05
Hello all,

I'm trying out different database designs and want to benchmark their performance in terms of speed.

The only operations that matter to me are Select and Count.

How can I run a few thousand Selects and then get the time taken using a Perl script and the DBI?

Thanks
0
Comment
Question by:xfvgdrthbdtyvhgscv
1 Comment
 
LVL 26

Accepted Solution

by:
ushastry earned 500 total points
ID: 12181076
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
Foreword This is an old article.  Instead of using the MySQL extension that was used in the original code examples, please choose one of the currently supported database extensions instead.  More information is available here: MySQLi / PDO (http://…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question