Thanks for the mail.
We ran analyze with no indexes, made no difference.
We recreated the indexes and ran analyze again. The very long commit is
back, this time it took 14 secs :)
It does appear that the indexes have something to do with this whereby
they have not been an issue to now.
Rob
On 29 Jul 2018, at 11:45, J. King wrote:
On July 29, 2018 5:47:29 AM EDT, Rob Willett
<rob.sql...@robertwillett.com> wrote:
John,
Thanks for the prompt reply and a very good question..
We've dropped the indexes and the commit is now very quick, approx
two
seconds
However the overall performance of the run is much the same as other
areas of the code are now significantly slower, whereas before they
were
quick.
Where were you going with that question?
Might ANALYZE help?
--
J. King
_______________________________________________
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
