Re: Performance Problem Selecting "double" Filed
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
Subject
Views
Written By
Posted
2717
April 06, 2005 08:04AM
Re: Performance Problem Selecting "double" Filed
1757
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.