Without more info it's impossible to say. The immediate possibility coming to mind would be if you're running in WAL mode, and that happened to be the commit that triggered a checkpoint, meaning you have both the commit time and the checkpoint time in there. Depending on how much there was to be checkpointed that could add up.
-----Original Message----- From: sqlite-users <sqlite-users-boun...@mailinglists.sqlite.org> On Behalf Of GopiKrishna Parisa Sent: Thursday, October 10, 2019 9:35 AM To: sqlite-users@mailinglists.sqlite.org Subject: [sqlite] insertion of a single record taking more than 200 msec some times Hi, i have a requirement to store logs while my app is running. i am using sqlite3 to store logs. i was trying to get some benchmark data by inserting logs on top of 60000 records. One weird thing is for some insertions, it's taking more than 200 msec for single record where as others takes around 20 to 40 (avag 27 msec). May i know what is the reason for this? Thank you. Regards, Gopikrishna P. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
