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
