Dear Community, Assuming that SQLite would arrange the database table contents on page boundary and
1) if db is small let us say maximum 5MB, 2 further if such a db is part of windows service / application running continuously then may be pages will remain in the memory under normal conditions. Q1) Operating System like Windows would cache the series of pages, is this behavior not almost same as that of Cache? Q2) Does it make sense to use In-memory SQLite for small size db upto 5MB average size 2MB? Thank you
