sqlite32.cpp

#include <iostream>
#include <string>
#include <sstream>
#include <time.h>
#include <strings.h>
#include <string.h>

#include "sqlite3.h"

const int nCount = 500000;

int main ( int argc, char** argv )
{
  sqlite3* db;
  sqlite3_open ( "testdb.db", &db );
  sqlite3_exec ( db, "PRAGMA synchronous = OFF; ", 0, 0, 0 );
  sqlite3_exec ( db, "drop table if exists t1", 0, 0, 0 );
  sqlite3_exec ( db, "create table t1(id integer,x integer,y integer ,weight real)", 0, 0, 0 );
  clock_t t1 = clock();

  sqlite3_exec ( db, "begin;", 0, 0, 0 );
  sqlite3_stmt* stmt;
  const char* sql = "insert into t1 values(?,?,?,?)";
  sqlite3_prepare_v2 ( db, sql, strlen ( sql ), &stmt, 0 );

  for ( int i = 0; i < nCount; ++i )
  {
    // std::stringstream ssm;
    // ssm<<"insert into t1 values("<<i<<","<<i*2<<","<<i/2<<","<<i*i<<")";
    // sqlite3_exec(db,ssm.str().c_str(),0,0,0);
    sqlite3_reset ( stmt );
    sqlite3_bind_int ( stmt, 1, i );
    sqlite3_bind_int ( stmt, 2, i * 2 );
    sqlite3_bind_int ( stmt, 3, i / 2 );
    sqlite3_bind_double ( stmt, 4, i * i );
    sqlite3_step ( stmt );
  }

  sqlite3_finalize ( stmt );
  sqlite3_exec ( db, "commit;", 0, 0, 0 );
  clock_t t2 = clock();

  sqlite3_close ( db );

  std::cout << 1000.0 / ( ( t2 - t1 ) / 1000.0 ) *nCount << " rec/s" << std::endl;

  return 0;
}