Solved

How to benchmark mysql databse performance using Perl DBI?

Posted on 2004-09-29
1
331 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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Fore-Foreword Today (2016) Maxmind has a new approach to the distribution of its data sets.  This article may be obsolete.  Instead of using the examples here, have a look at the MaxMind API (https://www.maxmind.com/en/geolite2-developer-package). …
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

786 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