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

[big-mulberry]

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]

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]

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

[fnc12]

@big-mulberry no news?