On 3 Aug 2018, at 8:36pm, Shevek <sql...@anarres.org> wrote: > We are running a 100Gb sqlite database, which we mmap entirely into RAM. We > are having trouble with parts of the disk file being evicted from RAM during > periods of low activity causing slow responses, particularly before 9am. Has > anybody played with mlock and/or madvise within the sqlite mmap subsystem to > improve this behaviour?
Is this a genuine Linux machine running on physical hardware, or is it a virtual machine ? Are you intentionally doing anything that would contend for this memory ? In other words, when a memory-mapped portion gets swapped out, does it make sense what replaced it, or is it pointless and weird ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
