# # patch "ChangeLog" # from [91b299e988e2995482fe3832fc9ee83b4f0e567c] # to [9f4a2229c71435605004d1bb96fff88c66a233bc] # # patch "schema.sql" # from [ac99524347304a61fe2d857bc45d1bcca73adb6e] # to [513edf45fe7238d23513b7062d965000271e2d67] # ======================================================================== --- ChangeLog 91b299e988e2995482fe3832fc9ee83b4f0e567c +++ ChangeLog 9f4a2229c71435605004d1bb96fff88c66a233bc @@ -1,3 +1,9 @@ +2005-09-01 Matt Johnston + + * schema.sql: add BEGIN, COMMIT to make it a single transaction, + improves db init performance significantly on OS X (avoids many + disk-cache flushes). + 2005-09-01 Matthew Gregan * testsuite.at: Increase entropy used to generate port numbers ======================================================================== --- schema.sql ac99524347304a61fe2d857bc45d1bcca73adb6e +++ schema.sql 513edf45fe7238d23513b7062d965000271e2d67 @@ -13,6 +13,8 @@ -- licensed to the public under the terms of the GNU GPL 2.1+ -- see the file COPYING for details +-- Transactions avoid syncing for each action, db init gets faster. +BEGIN; -- primary data structures concerned with storing and -- versionning state-of-tree configurations @@ -117,3 +119,5 @@ value not null, -- var value unique(domain, name) ); + +COMMIT;