Cecil Westerhof wrote: > I see that in certain older queries I use: > LIMIT (SELECT COUNT(*) FROM TABLE) > > It looks like this has no use (limiting the selected records to the > number of records there are). Anyone an idea what could be a reason for > this?
Trying to put some table data into the cache? Reading into a fixed-sized array, and protecting against concurrent inserts (from inside the same transaction)? Needing the LIMIT clause for some reason (disabling subquery flattening?) but not knowing about "LIMIT -1"? Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users