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;");