Sounds about right. How have you got your my.cnf set? Have you got RAID on you HDD? Simon
-----Original Message----- From: Florian Wilken [mailto:[EMAIL PROTECTED]] Sent: 23 May 2002 10:17 To: [EMAIL PROTECTED] Subject: MySQL Query Speed Hello our database consists of one table with approx. 150 columns. We have a query going over 11 columns (most tinyint, int and some varchar) Out of 217237 rows the query found 56 matches. Without Indexing, the query took 2,55 seconds. With Indexing, the query took 0,04 seconds. The database and query is currently being tested on the following computer: AMD Athlon(TM) XP1700+ (1500MHz), 768MB RAM MySQL 3.23.41 unter SuSE Linux 7.3 (Kernel 2.4.10-4GB) Is the speed of the query (2,55 sec, respectively 0,04 seconds) reasonable ? With the Index, should the query even be faster than 0,04 seconds ? Thanks for your Help. Flo --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
