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

Reply via email to