From: Derick H Siddoway
Date: March 22 1999 7:46pm
Subject: Some speed test fun
List-Archive: http://lists.mysql.com/mysql/791
Message-Id: <0897836F69E3000F*/c=us/admd=attmail/prmd=amex/o=unresolved/ou=HUB1/ou=AMEX/s=Siddoway/g=Derick/i=H/@MHS>

Hi.

I'm running on a dual-pentium75 with 160MB of memory.  (That's about 
113BogoMips
for you propeller-heads.)  I'm hosting mysql on an UW SCSI disk on a BusLogic
controller.

I'm doing some testing for a friend of mine, who wants to see if he should
abandon some AS/400&db2 development in favor of mysql.

Anyway, the database is very simple, only an indexed sequence number and
a random number (0-1000).  I wrote some C to generate this and had it generate
over 62 million records.  (I was aiming for 100 million, but I got impatient 
--
it took over 2 days to generate these records.)

But a simple SELECT * FROM test WHERE test_value < 100 only takes 11+ minutes.

He's impressed.

I'm working on generating a second table so we can do some joins.  I'll let 
you
know when I get some results back on that.

-- 
derick