Re: Performance on different platforms

[Tonu Samuel]

"Jeremy D. Zawodny" wrote:

> I recently benchmarked (via mysql-super-smack) a new machine I setup
> with MySQL. It's a 2 CPU Pentium III 850 with 1GB of memory. With a
> key cache of 384MB and other generous caches, I was able to sustain
> just under 7,000 queries per second using test queries that always hit
> keys.
> 
> When I added occasional updates to the list of queries it dropped to
> about 2,500 queries per second.

BTW, this is in big part parser speed. On my home uniprocessor
P3-600/128M/6G IDE disk I was able to write 12500 records per second
into database with multirow INSERT clause. I wrote 500 rows with one
command for this.

-- 
+----------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___                           |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Tõnu Samuel           |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|     tonu@stripped        |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Tallinn, Estonia      |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                       |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                      |
|             /*/             \*\                Developers Team |
+----------------------------------------------------------------+