[AppDB] - application class performance speedup

[Chris Morgan]

The application class fetches a list of versions that are frequently used by 
outside code.  The appVersion table has a primary key on versionId but no 
index on appId.  Adding an index on appdb improves the performance of selects 
on this table, the most frequent operation performed on the table.

ALTER TABLE `appVersion` ADD INDEX ( `appId` ) 

Chris
-------------- next part --------------
A non-text attachment was scrubbed...
Name: appversion_index.patch
Type: text/x-diff
Size: 594 bytes
Desc: not available
Url : http://www.winehq.org/pipermail/wine-patches/attachments/20060710/c683a3de/appversion_index.patch