From the SQLite shell (CLI), have you tried dot commands ".backup" to file and ".restore" to a new :memory: DB? That assumes a few things like access to the filesystem and sufficient user memory quota to hold the disk version of the DB. Does that work?
The shell dot commands and their syntax is explained here: https://sqlite.org/cli.html On Wed, May 17, 2017 at 10:18 PM, Gabriele Lanaro <gabriele.lan...@gmail.com > wrote: > 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
