MySQL Forums
Forum List  »  General

does number of fields in a table affect query performance
Posted by: Sava Rados
Date: April 26, 2005 08:22AM

Hello all,

I have big table (InnoDB): 70 fields, 6 million records. I have another table with 10 fields (fields that I currently use for queries) taken from first table and same 6 million records.

Identical query (forcing identical indexes) over the table with fewer fields works some 4 times faster.

I wonder how rest of fields can affect the query when they are not even used?!?

Thanks

Options: ReplyQuote


Subject
Written By
Posted
does number of fields in a table affect query performance
April 26, 2005 08:22AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.