Hi , I see that in release history for 3.8.1 below item. "Estimate the sizes of table and index rows and use the smallest applicable B-Tree for full scans and "count(*)" operations."
Does it mean that performance of count(*) has been improved in 3.8.1 and if yes by how much? We were using count (*) to get row count in our application and it was terribly slow if we have 2 Million records.Just wanted to know if we upgrade from 3.8.0 to 3.8.1 or 3.8.2 will there be any improvement in the query performance? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users