Package com.almworks.sqlite4java

Examples of com.almworks.sqlite4java.SQLiteConnection.exec()

111
112
113
114
115
116
117
118
119
120
121
      // In EMR the big disks are at /mnt
      // It suffices to set it to . as it is the tasks' work directory
      // Warning: this pragma is deprecated and may be removed in further versions, however there is no choice
      // other than recompiling SQLite or modifying the environment.
      conn.open(true);
      conn.exec("PRAGMA temp_store_directory = '" + new File(".").getAbsolutePath() + "'");
      SQLiteStatement st = conn.prepare("PRAGMA temp_store_directory");
      st.step();
      LOG.info("Changed temp_store_directory to: " + st.columnString(0));
      // journal_mode=OFF speeds up insertions
      conn.exec("PRAGMA journal_mode=OFF");
View Full Code Here
116
117
118
119
120
121
122
123
124
125
126
      conn.exec("PRAGMA temp_store_directory = '" + new File(".").getAbsolutePath() + "'");
      SQLiteStatement st = conn.prepare("PRAGMA temp_store_directory");
      st.step();
      LOG.info("Changed temp_store_directory to: " + st.columnString(0));
      // journal_mode=OFF speeds up insertions
      conn.exec("PRAGMA journal_mode=OFF");
      /*
       * page_size is one of of the most important parameters for speed up indexation. SQLite performs a merge sort for
       * sorting data before inserting it in an index. The buffer SQLites uses for sorting has a size equals to
       * page_size * SQLITE_DEFAULT_TEMP_CACHE_SIZE. Unfortunately, SQLITE_DEFAULT_TEMP_CACHE_SIZE is a compilation
       * parameter. That is then fixed to the sqlite4java library used. We have recompiled that library to increase
View Full Code Here
127
128
129
130
131
132
133
134
135
136
137
       * SQLITE_DEFAULT_TEMP_CACHE_SIZE (up to 32000 at the point of writing this lines), so, at runtime the unique way
       * to change the buffer size used for sorting is change the page_size. page_size must be changed BEFORE CREATE
       * STATEMENTS, otherwise it won't have effect. page_size should be a multiple of the sector size (1024 on linux)
       * in order to be efficient.
       */
      conn.exec("PRAGMA page_size=8192;");
      connCache.put(partition, conn);
      // Init transaction
      for(String sql : getPreSQL()) {
        LOG.info("Executing: " + sql);
        conn.exec(sql);
View Full Code Here
132
133
134
135
136
137
138
139
140
141
142
      conn.exec("PRAGMA page_size=8192;");
      connCache.put(partition, conn);
      // Init transaction
      for(String sql : getPreSQL()) {
        LOG.info("Executing: " + sql);
        conn.exec(sql);
      }
      conn.exec("BEGIN");
      Map<String, SQLiteStatement> stMap = new HashMap<String, SQLiteStatement>();
      stCache.put(partition, stMap);
    } catch(SQLiteException e) {
View Full Code Here
134
135
136
137
138
139
140
141
142
143
144
      // Init transaction
      for(String sql : getPreSQL()) {
        LOG.info("Executing: " + sql);
        conn.exec(sql);
      }
      conn.exec("BEGIN");
      Map<String, SQLiteStatement> stMap = new HashMap<String, SQLiteStatement>();
      stCache.put(partition, stMap);
    } catch(SQLiteException e) {
      throw new IOException(e);
    } catch(SploutSQLOutputFormatException e) {
View Full Code Here
211
212
213
214
215
216
217
218
219
220
221
      pS.reset();

      records++;
      if(records == getBatchSize()) {
        SQLiteConnection conn = connCache.get(partition);
        conn.exec("COMMIT");
        conn.exec("BEGIN");
        records = 0;
      }
    } catch(SQLiteException e) {
      throw new IOException(e);
View Full Code Here
212
213
214
215
216
217
218
219
220
221
222
      records++;
      if(records == getBatchSize()) {
        SQLiteConnection conn = connCache.get(partition);
        conn.exec("COMMIT");
        conn.exec("BEGIN");
        records = 0;
      }
    } catch(SQLiteException e) {
      throw new IOException(e);
    }
View Full Code Here
119
120
121
122
123
124
125
126
127
128
129
        }
        // set 1GB cache_size:
        final SQLiteStatement stmt = db.prepare("PRAGMA page_size;");
        if (stmt.step()) {
            long cacheSize = stmt.columnLong(0);
            db.exec("PRAGMA cache_size = " + (1024l*1024l*1024l / cacheSize) + ";");
        }
        stmt.dispose();
        db.exec("PRAGMA synchronous = OFF;");
        db.exec("PRAGMA journal_mode = OFF;");
//        db.exec("PRAGMA locking_mode = EXCLUSIVE;");
View Full Code Here
122
123
124
125
126
127
128
129
130
131
132
        if (stmt.step()) {
            long cacheSize = stmt.columnLong(0);
            db.exec("PRAGMA cache_size = " + (1024l*1024l*1024l / cacheSize) + ";");
        }
        stmt.dispose();
        db.exec("PRAGMA synchronous = OFF;");
        db.exec("PRAGMA journal_mode = OFF;");
//        db.exec("PRAGMA locking_mode = EXCLUSIVE;");
        db.exec("PRAGMA case_sensitive_like = true;");
        db.exec("PRAGMA encoding = 'UTF-8';");
        db.exec("PRAGMA temp_store = MEMORY;");
View Full Code Here
123
124
125
126
127
128
129
130
131
132
133
            long cacheSize = stmt.columnLong(0);
            db.exec("PRAGMA cache_size = " + (1024l*1024l*1024l / cacheSize) + ";");
        }
        stmt.dispose();
        db.exec("PRAGMA synchronous = OFF;");
        db.exec("PRAGMA journal_mode = OFF;");
//        db.exec("PRAGMA locking_mode = EXCLUSIVE;");
        db.exec("PRAGMA case_sensitive_like = true;");
        db.exec("PRAGMA encoding = 'UTF-8';");
        db.exec("PRAGMA temp_store = MEMORY;");
        return db;
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.