Ken <[EMAIL PROTECTED]> wrote: > Igor I disagree, but please feel free to correct me if I'm wrong. > Consider the following sql statement: > > select * from table1 order by last_name; > > Sqlite must first order the data since an order by clause is > specified. (assuming there is no index to utilize).
Yes, in some cases, SQLite might know internally how many rows there are by the time the first row is produced. This is not the case in general, though. Anyway, as far as I can tell there is no public API to retrieve this information even when it's available. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
