Hello Stefan, Wednesday, June 18, 2008, 11:47:53 AM, you wrote:
SA> Is it possible to get the size of a table without running a count(*) SA> query on it? Even an approximated size would be good for me. SA> PostgreSQL has this value in a system table. Does SQLite have SA> something similar? SA> S. SA> _______________________________________________ SA> sqlite-users mailing list SA> sqlite-users@sqlite.org SA> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users Yeah, it's not that fast at all. I moved away from SQLite for one part of my application because COUNT was slow. If the data's not in the OS cache, it's real slow. One possibility would be to maintain an approximate count in a different table. That didn't work for me because my counts were time dependent and depended on some RE filtering. -- Best regards, Teg mailto:[EMAIL PROTECTED] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
