Well the number of returning rows don't always say something about the number of rows MySQL has to process, select, join and sort, before it can return that number of rows.
A select with a '...FROM singletable WHERE column = 1' that would select 75 out of the 150 rows, would be very fast.
Selecting from multiple big tables, joining on nonunique fields, sorting, etc, still returning 75 rows could be very time consuming.
06-27-2005, 03:53 PM
Threaded Mode