sqlite3快速插入数据

#ifdef _DEBUG
#pragma comment(lib,“sqlite3-mtd-unicode.lib”)
#else
#pragma comment(lib,“sqlite3-mt-unicode.lib”)
#endif // DEBUG

sqlite3 *db = NULL;
std::string path = "D:/C++Project/sqlite3-test/Debug/test.db";
int re = sqlite3_open_v2(path.c_str(), &db, SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE | SQLITE_OPEN_NOMUTEX | SQLITE_OPEN_SHAREDCACHE, NULL);//最后必须sqlite3_close_v2(sql);关闭
re = sqlite3_exec(db, "begin;", 0, 0, 0);
re = sqlite3_exec(db, "PRAGMA synchronous = OFF; ", 0, 0, 0);
sqlite3_stmt *stmt;

const char* sql = "insert into company values(?,?,?,?,?);";
re = sqlite3_prepare_v2(db, sql, strlen(sql), &stmt, 0);
SYSTEMTIME time;
GetLocalTime(&time);
double tt = time.wMinute *1000*60 + time.wSecond * 1000 + time.wMilliseconds;
cout << time.wSecond << " " << time.wMilliseconds << endl;
for (int i = 5; i<100; ++i)
{
	sqlite3_reset(stmt);
	sqlite3_bind_int(stmt, 1, i);
	sqlite3_bind_int(stmt, 2, i);
	sqlite3_bind_int(stmt, 3, i);
	sqlite3_bind_double(stmt, 4, i);
	sqlite3_bind_int(stmt, 5, i);
	re  = sqlite3_step(stmt);
}
sqlite3_finalize(stmt);//每个sqlite3_prepare_v2对应一个，不然内存暴炸
GetLocalTime(&time);
tt = time.wMinute * 1000 * 60 + time.wSecond * 1000 + time.wMilliseconds - tt;
cout << "毫秒 = " << tt/60000<<" " <<(tt - tt/60000)/1000<<" " <<tt- (tt - tt / 60000) / 1000 << endl;
cout << time.wSecond << " " << time.wMilliseconds << endl;

sqlite3_exec(db, "commit;", 0, 0, 0);