From: adam <adam@megacz.com>
Date: Thu, 5 Jul 2007 01:35:17 +0000 (+0000)
Subject: add setCacheSize()
X-Git-Url: http://git.megacz.com/?p=org.ibex.mail.git;a=commitdiff_plain;h=e1d77cb9860a971c4b1b5416697be8cd3d34acfd

add setCacheSize()

darcs-hash:20070705013517-5007d-ee9e3c939236b4ad76524b211c6b5ca0ed0cb547.gz
---

diff --git a/src/org/ibex/mail/SqliteTable.java b/src/org/ibex/mail/SqliteTable.java
index 91dcb53..f24fabf 100644
--- a/src/org/ibex/mail/SqliteTable.java
+++ b/src/org/ibex/mail/SqliteTable.java
@@ -18,6 +18,15 @@ public class SqliteTable {
     private String reapTable;
     private String reapColumn;
 
+    // check upstream: PRAGMA encoding = "UTF-8"; 
+    // create indices
+    // PRAGMA auto_vacuum=1  (can only be set before any tables are created)
+    // periodic "PRAGMA integrity_check; "?
+
+    public void setCacheSize(int kilobytes) throws SQLException {
+        conn.prepareStatement("PRAGMA cache_size="+Math.ceil(kilobytes/1.5)+";").executeUpdate();
+    }
+
     public SqliteTable(String filename, String[] tables, String reapTable, String reapColumn) {
         this(filename, tables, false, reapTable, reapColumn);
     }