On 3/28/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
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?
Using a trigger to maintain a table count on an auxiliary table after
every insert/delete is the prefered way.
This was discussed before on the list and i believe there is an
example on how to do this.
Regards,
~Nuno Lucas
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
