On 25 Oct 2013, at 11:54pm, Mike Clagett <mike.clag...@mathworks.com> wrote:
> Both interactively in the Firefox tool and programmatically from the second > phase of my application it takes about an average 18ms to do a select -- the > same amount of time without the index even being there at all. Only when I > manually drop and recreate the index from within the Firefox tool does the > index kick in and subsequently reduce select time to about 1ms. Use the SQLite shell tool for your platform and try the same thing. Do you get the same results ? <http://www.sqlite.org/download.html> The SQLite shell tool was written by the SQLite development team and if you get weird behaviour in it they have everything they need to isolate the problem. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
