Have you actually got speed issues, or is this just a case of "this should be faster"? If you DO have speed issues, my experience from reading this list is that most can be improved with better SQL, better indices, or better interplay between readers and writers. Only if those have been exhausted should you be looking at compile options. Graham.
Sent from my Samsung Galaxy S7 - powered by Three -------- Original message --------From: advancenOO <haveagoodtime2...@gmail.com> Date: 11/12/2017 14:04 (GMT+00:00) To: sqlite-users@mailinglists.sqlite.org Subject: [sqlite] Enabling MMAP in Android I find MMAP is able to be used for db files(getPageMMap()) but is not enabled by default. I wonder if it is recommended to use MMAP in Android? As I think MMAP is one way to improve the speed performance(I use speedtest1.c to evaluate). At the same time, Mmap() is only used for reading by default, not writing. But why? And in what situation I can compile with the -DSQLITE_MMAP_READWRITE option? By the way, is there any other recommended compile-options? I find some references in http://www.sqlite.org/compile.html <http://www.sqlite.org/compile.html> , but I am wondering if there is any other method to enhance performance? Thanks for your help. -- Sent from: http://sqlite.1065341.n5.nabble.com/ _______________________________________________ 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
