[AppDB] - performance improvements

[Chris Morgan]

Version class should defer creation of nearly all of its internal arrays until 
necessary.  Except for one of these arrays the rest are only used when a 
version is being deleted so move the creation of the arrays to 
version::delete().  Moving these removes 7 sql queries from the creation of 
each version object.

Application should do the same with its aUrlsIds as these are only used upon 
deletion.

Screenshot class only needs to query the database for the columns required, 
not all columns as there are a handful of unused columns in the 'select *' 
case.

Chris

-------------- next part --------------
A non-text attachment was scrubbed...
Name: performance.patch
Type: text/x-diff
Size: 15793 bytes
Desc: not available
Url : http://www.winehq.org/pipermail/wine-patches/attachments/20060708/d49a457b/performance-0001.patch