"yaroslavp" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > For testing purposes, I created a single row with a large blob > (hundreds of megs) in my database. There is also an integer column. > When I do an update on the integer, the query is very slow, and > there's a lot of disk activity. The bigger the blob, the slower the > query (a rule of thumb - one second per 20 megabytes of blob size on > a low-end PC). Synchronous is OFF.
Make sure the blob field is listed last in CREATE TABLE. Otherwise, SQLite would have to read the whole blob before it could get to the integer. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
