Subject Re: [firebird-support] Re: Table with more than 100 index.
Author Ivan Prenosil
>> 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.