MySQL Forums
Forum List  »  Performance

Re: Performance Problem Selecting "double" Filed
Posted by: Sergey Petrunya
Date: April 07, 2005 05:43AM

It's difficult to tell whether the performance can be increased as it depends on many factors, but

1) Selecting only the fields you need might increase performance as there will be less data to copy/send to the client. The actual gain will vary depending on where the bottleneck was.

2) Do you have any indexes on the table? If the table has an index that covers all the selected fields, MySQL might not perform full table scan but scan the index instead. In EXPLAIN it is displayed as "index" in "type" column (instead of "all" for full table scan).

If you need only a small fraction of table fields consider adding an index on that fields.

Sergey Petrunia, Software Developer
MySQL AB, www.mysql.com
My blog: http://s.petrunia.net/blog

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Performance Problem Selecting "double" Filed
1617
April 07, 2005 05:43AM


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.