Paolo Vernazza wrote:
Trygg Johan wrote:
Hello,
I'm using SQLite with TCL and I have a small question:
Is it possible to get information on how many lines a select query with
the LIMIT keyword would have produced if I hadn't used the LIMIT
keyword?
One way of doing this would be to do another query without the LIMIT
keyword, count the number of lines you got, and then throw away the
resulting data, but this seem to be a bit of waste of both resources and
time... so I hope someone has a better solution :)
Thanks in advance,
Johan Trygg
I'm not sure what do you need... but you tried using
SELECT COUNT(*) FROM etc etc etc
IMHO COUNT does a complete tablescan to count the records, it did in a
previous version of sqlite
Bert
?
Paolo
