--- In firebird-support@yahoogroups.com, "Ivan Prenosil" <Ivan.Prenosil@...> wrote:
>
> >> The only solution to this problem is to maintain an auxiliary table for each
> >> field in the main table with the fields "value" and "counter" . Use triggers
> >> on the main table to maintain these tables. Then you can quickly get the
>
> >i was already thing about this, but how you handle the lock conflict ?
> > if user A update row 1234 so he update also the count in table AUX and if user B update the row 493845 so he also update the count
> > in table AUX => lock problem :(
>
> I do not think counters for separate fields can help in your situation,
> because you need to know number of rows for whole WHERE clause.
>
> Ivan
>