From: Martin Edelius Date: March 22 1999 8:49pm Subject: SV: Some speed test fun List-Archive: http://lists.mysql.com/mysql/799 Message-Id: <003601be74a5$97eefb80$645ca8c0@asylum.spirex.se> >But a simple SELECT * FROM test WHERE test_value < 100 only takes 11+ minutes. > >He's impressed. Ok. For those of us with little experienced with this type of databases (62 million records and counting), what is expected? Why is 11+ (I assume that this means more than 11 but less than 12, right?) good? How slow/fast is the AS/400? Sorry if this is a strange Q but I'm really curious... Best regards, Martin Edelius Spirex Digital Design -------------------------------- www: http://www.spirex.se Mail: martin.edelius@stripped Phone: +46-31-514651, 0708-113711 Fax: +46-31-514331 Aröds Industriväg 3c S-422 43 Hisings Backa --------------------------------