--- In firebird-support@yahoogroups.com, "GOVINDKRISHNA"
<gkrishna@j...> wrote:

> Ali,
>
> This looks good.
>
> Thank you very much.
>
>
>
> Regards
>
> S. Govindkrishna
> JL Infomatrix Limited
>

You are welcome.

You can create table for each counter type for speed/store
optimisation. ( with only 3 integer fields)
main point is, insert counter record and be sure it is commited.
Then, rebuild tables to sync. with last state with lock tolerated
operation. (don't forget to rollback if there is lock exception)
it will be as fast as possible with minimum table size.

Take it easy.

Ali