It is driving me crazy. I'm working on a web spider where a table holds the downloaded webpage. It seems that a select
"SELECT count(*) WHERE NOT text IS NULL" requires that the complete text column is loaded. With a stored LOB this results in crazy performance. Is this optimized in later versions of SQLite (i'm using a 3.4.x which is about 2 years old). _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users