"Marian Aldenhoevel" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > CREATE INDEX IF NOT EXISTS IDX_KFZ_MUSTRANS ON KFZ (mustTrans); > > The problem is with bulk-updating: > >> # time sqlite3 kfzdb 'update kfz set musttrans=3' >> real 10m 7.75s >> user 8m 49.73s >> sys 0m 24.29s > > 10 minutes is too long.
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. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
