>> A follow up to this. If I run ANALYZE on the ?fast? version of the database >> - ie *after* I?ve recreated the index - performance drops back to the >> original slow speed. > > Please run ".fullschema" using the sqlite3.exe command-line shell on > your original database and send us the output.
Hi there, Thanks for your reply, Richard. I?ve done that, and it?s listed all the CREATE TABLE and CREATE INDEX commands, as well as all the triggers I?ve got in there, and a bunch of ?INSERT INTO sqlite_stat1? statements. I don?t want to share the result in a public forum, because I don?t want the structure of our tables or the code of our triggers to be out there in the wild (normally our database is encrypted, so nobody without the key can look into it). I?m happy to send it to you off-list if you?ll keep it confidential and would find it useful, or I can strip out all the triggers and, perhaps, the tables which aren?t relevant, and post it publicly? If that would help, do tell me what it is that you?re wanting to look at. Best wishes, Hamish PS Not that it should make any difference, but I?m running Mac OS X. I can run the same tests on Windows if it would be helpful. -- Hamish Symington 07815 081282 : info at hamishsymington.com I also set custom cryptic crosswords: www.customcrypticcrosswords.com (@CustomCryptics on Twitter)
