MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Martin Edelius Date:March 22 1999 8:49pm
Subject:SV: Some speed test fun
View as plain text  
>But a simple SELECT * FROM test WHERE test_value < 100 only takes 11+
>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

Mail: martin.edelius@stripped
Phone: +46-31-514651, 0708-113711
Fax: +46-31-514331
S-422 43 Hisings Backa

SV: Some speed test funMartin Edelius22 Mar