[sqlite] what's the fastest way to get the record count of a table?

[qinligeng]

Hi,
I want to check the record count of a table every 5 seconds.
It seems there's only one way to get a table's record count:
select coun(*) from ATable

but if the table gets big(1,000,000 rows), it will get slow.
Any good idea?