I'm doing some benchmarks in order to understand where are the bottlenecks in my solution and I found that a SQL query on a table with 12000 records takes 0,87 seconds to preform (Dual 800 G4 MacOS X Server) 0,87 sec may seem fast but it is not on a solution which is going to have a lot of traffic... Is this normal?
It is a very simple query on a INTEGER field (data size = 8, unsigned integer) in which I ask all the records that have that field >= (var: 'limit'). Here is the code: SELECT threads.closed, threads.id AS thread_id, threads.last_post_day AS thread_last_post_day, threads.last_post_time AS thread_last_post_time FROM threads WHERE threads.secondi > 37274986 ORDER BY threads.secondi DESC I added an index for the field 'secondi' but performance remained exactly the same after the index was added. Is it normal so much time from a query as simple as this? Thanx, Augusto --------------------------------------------------------------------- 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
