c++ - SQLite - Database file stops growing -


i'm using srombauts sqlite wrapper c++ sqlite version 3.8.10.2 on debian jessie machine.
can insert or select data without problems, strange thing is, database stops growing @ 56852480 bytes (i've got information ls -l database.db command).

what i'm trying accomplish insert data of big (around 280'000 lines) csv file database.

well, simplified version of code:

#include <iostream> #include <csv.h> //small csv class of mine #include <sqlitecpp/sqlitecpp.h> #include <string>  int main() {     sqlite::database db("database.db", sqlite_open_readwrite | sqlite_open_create);     db.exec("drop table if exists bernd");      //simplified version of table, there more columns     db.exec("create table bernd(id integer primary key, loads_of_data text)");     sqlite::transaction tr;     sqlite::statement stmt("insert bernd(loads_of_data) values(?)");      csv csv("file.csv");     while(csv.getnext())     {         stmt.bind(1, csv.getvalue("loads_of_data"));         stmt.executestep();         stmt.reset();     }     tr.commit(); } 

i know should use try{} catch{} blocks, wanted keep code small.

i read things sqlite limits setting 1 significant case, sqlite_max_page_count, it's maximum value made no difference.

what's going on here? seems no 1 else encountered problem , i'm confused!
insight or hint right direction highly appreciated!


Comments

Popular posts from this blog

android - Gradle sync Error:Configuration with name 'default' not found -

java - Andrioid studio start fail: Fatal error initializing 'null' -

html - jQuery UI Sortable - Remove placeholder after item is dropped -