[Monotone-devel] [patch] PRAGMA page_size=8192

[Joe Wilson]

I think this is the file where the pragma goes.

The 8192 byte SQLite page size reduces most large monotone 
databases by 23% while requiring no c++ code changes.
It will work with any monotone version.
Database read access is marginally faster.
There is no downside.

# 
# old_revision [f28f306ccd3ff2c57df9d0005876a00370af2739]
# 
# patch "schema.sql"
#  from [f44144278a4158695818d8f7e1901ac6f89e39bb]
#    to [e366da7f4ca8ed2a98230e24fb5186342eaf8349]
# 
============================================================
--- schema.sql  f44144278a4158695818d8f7e1901ac6f89e39bb
+++ schema.sql  e366da7f4ca8ed2a98230e24fb5186342eaf8349
@@ -13,6 +13,9 @@
 -- licensed to the public under the terms of the GNU GPL 2.1+
 -- see the file COPYING for details
 
+-- must be first command in database.
+PRAGMA page_size=8192;
+
 -- Transactions avoid syncing for each action, db init gets faster.
 BEGIN EXCLUSIVE;
 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com