[AppDB] - performance improvements
Chris Morgan
cmorgan at alum.wpi.edu
Sat Jul 8 12:59:25 CDT 2006
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
More information about the wine-patches
mailing list