sqlite的效率是很高的,不过需要进行一下设置,才能达到高效:
EXECUTE_STATEMENT(hDB, "PRAGMA synchronous = OFF;");
EXECUTE_STATEMENT(hDB, "PRAGMA locking_mode = EXCLUSIVE;");
EXECUTE_STATEMENT(hDB, "PRAGMA cache_size = 12000;");
EXECUTE_STATEMENT(hDB, "PRAGMA temp_store = FILE;");