Hi, > Considering that all or most of the records have the same value in > musttrans column, do you really need an index on it? Try dropping the > index, see if it helps.
They have the same value in my test. In the real application that field is used as a status field and most of the records will have 0, and a few dozen something else. I have repeated the test without the index. The difference is negligible and probaply in the normal range of measurements using my dummy benchmarking-technique. > What happens when you run the update inside a transaction? I tried it like this: > time sqlite3 kfzdb 'begin ; update kfz set musttrans=5 ; end' No significant change in runtime either. Thank you for your suggestions so far. Anything else? The alternative is cleaning up the homebrew version used so far and adding some sort of indexing scheme to it. And I am definitely NOT looking forward to having to do that. It is extremely yucky code! Ciao, MM _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
