At 15:18 11.07.2003 +0530, you wrote:

>I am using this select count every twenty seconds from the client.
>Sometimes twenty or thirty clients will be running so sometimes the
>difference was growing to more than 3000 or 4000 but within around 3 or 4
>minutes it would come down to a hundred or so.

Now, why would anyone want to issue a 'SELECT COUNT(*) FROM TABLE' every
twentieth second? How could that possibly be useful?

Set