search

fnc12 / sqlite_orm

❤️ SQLite ORM light header only library for modern C++
GNU Affero General Public License v3.0
2.27k stars 313 forks source link

How to pre-expand when using the in-memory database mode? #1288

Open big-mulberry opened 4 months ago

big-mulberry commented 4 months ago

When I'm inserting data in memory mode, I frequently encounter page faults, which significantly impacts performance. Is there a way to pre-expand memory, allocating a certain size of memory space in advance? Currently, there are six tables, and a total of 300 double variables will be inserted within 1 millisecond.

fnc12 commented 4 months ago

hi @big-mulberry . The answer depends on how you would do this with raw SQLite cause it is more SQLite related question not sqlite_orm related question

big-mulberry commented 4 months ago

@fnc12 Thank you for your suggestion. I will go figure it out.

fnc12 commented 3 months ago

@big-mulberry no news?