> "SELECT count(*) WHERE NOT text IS NULL" > > requires that the complete text column is loaded. With a stored LOB > this results in crazy performance.
How did you find that? What do you mean by "requires loading of the whole text column"? It pretty much can require even loading of text columns that shouldn't be counted at all just because one database page is the minimum storage entity loaded from disk. Pavel On Sat, Feb 27, 2010 at 6:25 PM, Lothar Scholz <sch...@scriptolutions.com> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
