SQLite's Business

Long time no database, knowledge has forgotten, before using SQLite line insert data, found that this performance is too pit, 10w data, insertion took about 100 minutes.

Later found that there is a transaction such a thing, can greatly reduce the operation of the IO, the test inserted 40w data, about 5 minutes or so, than the previous insert but 666

WCHAR Szbuffer[max_path] = {0};  WCHAR szbuffer2[1024] = {0};for (int i = 0; i < 500000; i+=100) {wstring Strsql;strsql + = L "begin;\n"; for (int index = 0; Index <= 100;++index) {swprintf_s (Szbuffer, MAX_PATH, L "xxxxxxxxx.yyyyy.%d", I+index); swprintf_s (SzBuffer2, 1024, Insert_fileinfo_table, Szbuffer, True, 0.0f, true), strSQL + = Szbuffer2;strsql + = L "; \ n";} strSQL + = L "commit;"; FileInfo. Execute (Strsql.c_str ());}

SQLite's Business