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
Post a Comment