-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 04/02/13 23:33, Alex Cheng wrote: > I want to write a program to load a sqlite database on disk as an > in-memory database, for sake of reducing number of disk I/O operations. > Do you know how to achieve it?
You may not need to actually do that. Since your database is smaller than memory it should be sufficient to just read the file contents sequentially before opening in SQLite. This will populate the operating system file system cache so disk operations are served out of cache memory. (Doesn't work on XP with default settings but does work on every other modern operating system.) Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAlEQxrAACgkQmOOfHg372QTlLgCeLI2dZP/v6Pw4VlgcgRGUKqHB xcwAnjM1RAHNzGgvi9nnGnP4uoYG6vqV =DCOk -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
