Black, Michael (IS) wrote, On 26/04/12 21:39:
My fault...I thought I had extracted it under another name...turns out I was
using a different db...duh...
Looks like it uses the indexes just fine. I'm using the Window's EXE from the
website. Also got the same result on Unix.
Did you compile your own? Or did you check to see that the indexes still
weren't being used on your subset?
I compiled the amalgamation:
cc -o sqlite3 -O2 shell.c sqlite3.c -llpthread -ldl
Sorry, forgot to answer that.
The Arch build source is http://www.sqlite.org/sqlite-autoconf-3071100.tar.gz
The build runs ./configure --prefix=/usr --disable-static
Then make with CFLAGS='CFLAGS -DSQLITE_ENABLE_FTS3=1
-DSQLITE_ENABLE_COLUMN_METADATA=1 -DSQLITE_ENABLE_UNLOCK_NOTIFY
-DSQLITE_SECURE_DELETE'
Pete
--
Peter Hardman
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
