In my table which had about 300 million (sic.) rows I did this SELECT count(*) FROM myTable;
to count the number of rows. After half an hour it was still processing and I had to kill it. I know that the internal structure of a table means that this number isn't simple to produce. But is there really no faster way ? This table is going to have about six times that amount soon. I really can't count the rows in less than a few hours ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users