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.
sqlite-users mailing list