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

Reply via email to