hey,
i downloaded two databases off the mysql site (classicmodels and sakila). after running a few queries, i'm puzzled.
the table orderdetails in classicmodels db has rougly 3k rows.
when i search for one row (using different columns, i get these results):
primary key:0.0027s
other columns:0.0042s and 0.0054s
the table rental in the sakila db has more than 16k rows. again, when i search for a sinlge row(using different columns, these are the times):
primary key :0.0027s
column(date):0.0026s
column(again,date):0.0285s/0.026s
can anyone throw anylight as to why this is happening?