Re: Long Running Queries

2004-10-07 Thread m . muller
How do you do to benchmark a query ? I wish we had thought to have had him benchmark a query before and after he added an index. It would be interesting to see the difference in actual time that an index can make on a table with 450,000 records. On Wed, 2004-10-06 at 15:31, Jason Williard

Benchmaking queries...

2004-10-06 Thread m . muller
Hi MySql freaks ! Does someone know if it exists a more precise way to compare two queries on an other base than the time to process the request? For example, is it possible to know the numbers of flops needed or memory allocated to process the query ? Thanks in advance! Michael -- MySQL