On Wed, Feb 6, 2013 at 9:10 AM, Jason Gauthier <jgauth...@lastar.com> wrote:
> > Thanks so much for your ideas. Trying the PRAMGA mode was easy, so I did > that first: > > # time sqlite3 trip.db "PRAGMA journal_mode=WAL; delete from trip where > key<=1400;" > > real 0m1.410s > # time sqlite3 trip.db "PRAGMA journal_mode=WAL; delete from trip where > key<=1600;" > > real 0m1.554s > # time sqlite3 trip.db "delete from trip where key<=1800;" > real 0m1.830s > I'm not sure that theses tests are meaningful. First off, the conversion to WAL mode takes time, and that time is being included in the result. Secondly, WAL mode is persistent. Once it is set it stays set until it is changed. So you cannot turn around and run another test after setting WAL mode and expect the subsequent test to be in rollback mode. What I would like to see is something like this: cp trip-original.db trip.db sqlite3 trip.db 'PRAGMA journal_mode=WAL' time sqlite3 trip.db 'DELETE FROM trip WHERE key<=1400' cp trip-original.db trip.db sqlite3 trip.db 'PRAGMA journal_mode=DELETE' time sqlite3 trip.db 'DELETE FROM trip WHERE key<=1400' > > I am struggling with sqlite4, though. I've never used fossil, so I may > have approached this wrong. I grabbed it with: > fossil clone http://www.sqlite.org/src4 sqlite4.fossil > and then 'fossil open sqlite4.fossil'. > You probably have fossil going, then. Which is good. But you could have just clicked on the "Download: Tarball" link or the "Download: ZIP Archive" link at http://www.sqlite.org/src4/info/7cc153f523 in order to get a copy of the latest code. Now that you have a fossil clone, you can always get the latest code by running: fossil update trunk > > However, there isn't a 'configure' inside this, so I am attempting to > 'make'. Unfortunately, the build environment is having a issues with this. > Did I grab the latest check-in the way you assumed I would? > Yeah - I guess we don't have a configure script yet. You'll need to edit the makefile to make it work on your system. My guess is that you probably just need to go to http://www.sqlite.org/src4/artifact/72944b28eb3a?ln=161-167 and select some compiler other than clang. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users