Changes between Version 6 and Version 7 of Database Optimization


Ignore:
Timestamp:
Dec 12, 2006, 1:12:35 PM (15 years ago)
Author:
david
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Database Optimization

    v6 v7  
    1111
    1212
     13David - According to http://www.mysqlperformanceblog.com/2006/11/23/covering-index-and-prefix-indexes/ then "that creates a single index -- those can't be split up" is incorrect, and (node_id, version) does not need its own index.
     14
    1315Nick - if you have lots of metadata, then adding an index on node_id,version is likely to help (we no longer have metadata_name)
    1416