I'm using sqlite in an embedded system. Disk I/O is relatively slow. I am doing a: SELECT count(*) FROM my_table; This is taking too much time. I've also tried count(1), as I saw suggested elsewhere in the mail list... though I'm not entirely sure what this means. 1st column? I've tried a column that I have an index for... not faster. Doesn't sqlite "know" the number of rows in each table without explicitly counting them? Thanks for any help Buzz
--------------------------------- Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing
