Drupal and PHP related posts - Drupal Chennai, Navaneethakrishnan.R
Friday, October 30, 2009
More Mysql Indexes affect performance on heavy traffic site
I want to share about index on table columns. Indexes are something extra that you can enable on your MySQL tables to increase performance, but they do have some downsides. When you create a new index MySQL builds a separate block of information that needs to be updated every time there are changes made to the table. This means that if you are constantly updating, inserting and removing entries in your table this could have a negative impact on performance. So avoid using index unnecessarily. That will affect the performance.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment