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
