SQLite Forum

Tips for getting SQLite under Python to perform better with more RAM?
Good.  There is also the issue of this so-called new-fangled re-invention of the pre-existing since the 1950's technology called "serverless" or "lambdas" (which is not really serverless at all, that is just a cutesy-pie name for the entertainment of the kiddies).

In this scenario, the so-called "server process" is not running all the time, but only on demand.  Therefore, it is always fired with a cold-cache and there will be zero improvement possible by increasing application level cache size.

The long and the short of it is that if the "process" you are trying to speed up is fired up from the cold, there is nothing you can do except to "stay warm" rather than shutdown between uses.  The performance of the cold-start will not be able to be improved.  Like all I/O, the fastest way to do it is to not do it at all.