"yokk y" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I want to get the total rows of a table, here are my methods: > > Is there some more efficient methods or API interface with > Sqlite?Because my program invoke this interface very frequency.
If it's really that important for you to have an accurate row count for a table, store this count in another table and use triggers to maintain it. SQLite doesn't internally maintain this count; the only way for SQLite to obtain it is to actually count rows one by one. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users