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] Very, very slow commits Rob Willett
- Re: [sqlite] Very, very slow commits Rob Willett
- Re: [sqlite] Very, very slow commits John Found
- Re: [sqlite] Very, very slow commits Rob Willett
- Re: [sqlite] Very, very slow commits R Smith
- Re: [sqlite] Very, very slow commits R Smith
- Re: [sqlite] Very, very slow commits J. King
- Re: [sqlite] Very, very slow commits Rob Willett
- Re: [sqlite] Very, very slow commits Djelf
- Re: [sqlite] Very, very slow commits Rob Willett
- [sqlite] Bug: Problem with sqlite3_prepare_v2 Jürgen Palm
- Re: [sqlite] Bug: Problem with sqlite3_prepare_v2 Richard Hipp
- Re: [sqlite] Bug: Problem with sqlite3_prepare_v... Jürgen Palm
- Re: [sqlite] Bug: Problem with sqlite3_prepa... Richard Hipp
- Re: [sqlite] Very, very slow commits Simon Slavin
- Re: [sqlite] Very, very slow commits Rob Willett
- Re: [sqlite] Very, very slow commits Rob Willett