Puneet Kishor writes: > Especially, note Pavel's recent, wonderful explanation of how SQLite steps > through the result set handing you the data row by row. It *has* to go > through the set to know how big the set is... there is no way around it. >
Actually, sometimes there are. Consider: SELECT COUNT(*) FROM t1, t2; SELECT (SELECT COUNT(*) FROM t1) * (SELECT COUNT(*) FROM t2); Of course, those are special cases. Application programmers should probably watch for this kind of thing, but it probably wasn't what the programmer wanted to count in the first place. --David Garfield _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users