On 10 Nov 2017, at 8:49am, advancenOO <haveagoodtime2...@gmail.com> wrote:
> Purely for speed :) > I hope to improve the performance inside sqlite in order to optimize the > performance of the upper applications. As there are so many different scenes > in APPs. hAve you optimised your column orders ? Have you created ideal indexes for the WHERE and ORDER BY clauses you use ? Have you made use of covering indexes ? Both those things speed up SQLite many times more than using memory mapping. Have you tried SQLite just as it is, without putting special effort into PRAMGAs ? SQLite is extremely fast without those things. There’s a good chance it’s fast enough and you’re just wasting your time. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users