I'm with Simon. If you're writing 5 million rows to memory, the OS has to move unused memory out to disk.
I'd say write the data to disk (SSD if you can) and check if the data written out is at a consistent speed. On Thu, Aug 27, 2015 at 10:29 PM, Simon Slavin <slavins at bigfraud.org> wrote: > > On 28 Aug 2015, at 3:15am, Yuri <yuri at rawbw.com> wrote: > > > * Database is written into memory > > [...] > > How can I understand why the slowdown occurs? Especially, why the > slowdown in so "sharp"? > > Your computer has a certain amount of free memory. Once your database is > bigger than that size the computer has to keep moving parts of the database > into storage so it has room for the new data. > > I will guess that if you got more RAM in your computer you would have > faster operations for longer. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
