--- In firebird-support@yahoogroups.com, "ajose_s18" <ajose_s18@...> wrote:

>
> Hi,
>
> Ok, the app do and insert each time it reads some codebar code, before the insert it verifies if it exist or if it was in another group. I checked the verification and all of them use index (there are two select one with count). The table where it verifies has 400k rows or more. For example, before the firebird update, each operation took something like 1/4 second, and it wasn't perceptible the delay, right now it take something like 1 sec, so when they are like 40 codebars it takes more time. I'm programming with CBuilder 6.
>
> Something that I didn't specified is that is SuperServer version.
>
> greetings

If this is SuperServer and 2.1 version
you should specify AffinityMask in Firebird.conf to set which processor should Firebird to use. Set only one to it and restart serwer. Check if this help.

Karol Bieniaszewski