Opened 13 years ago

Closed 13 years ago

#793 closed enhancement (fixed)

SQLite: Avoid caching too many statements

Reported by: romicadascalescu Owned by: romicadascalescu
Priority: major Milestone: 3.7.0
Component: SQLite Provider Version: 3.7.0
Severity: 3 Keywords:
Cc: External ID:

Description

SQLite: Avoid caching too many statements, right new we cache 1000 statements and after this count we clean up the cache, but at this number it might be too late. Added a lower number of cache statements. When we hit that number we verify is statements were used only once. In case yes we remove it from cache, in case no we keep it till we hit a bigger count when we decrement the usage count till will become 1 and will be removed from cache.

Change History (1)

comment:1 by romicadascalescu, 13 years ago

Resolution: fixed
Status: newclosed

New Revision: 6279

Modified:

trunk/Providers/SQLite/Src/Provider/SltProvider.cpp trunk/Providers/SQLite/Src/Provider/SltProvider.h trunk/Providers/SQLite/Src/Provider/SltReader.cpp

Log: #793: SQLite: Avoid caching too many statements

Note: See TracTickets for help on using tickets.