If by any chance you have access to Linux or alike, you can just mount a ramfs and move database file over there. It is a usual file system that lives in RAM. This will 100% guarantee you that no disk access will be made by SQLite.
18 May 2017, 08:18:47, by "Gabriele Lanaro" <gabriele.lan...@gmail.com>: > Hi, I'm trying to assess if the performance of my application is dependent > on disk access from sqlite. > > To rule this out I wanted to make sure that the SQLite DB is completely > accessed from memory and there are no disk accesses. > > Is it possible to obtain this effect by using pragmas such as cache_size? > > Another solution is to copy the existing db to a :memory: db but I'd like > to achieve the same effect without doing so (because it will require > substantial modification of the application). For the sake of argument, > let's image that using :memory: db is not an option. > > Also using a ramdisk is not an option because I don't have root access to > the machine. > > Thanks, > > Gabriele > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users