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

--- In firebird-support@yahoogroups.com, "karolbieniaszewski" <liviuslivius@...> wrote:
>
>
> --- In firebird-support@yahoogroups.com, "ajose_s18" <ajose_s18@> wrote:
> >
> > Hi, I recently update a Firebird from 1.5 to 2.1, I did a Backup/Restore, but now the app is slower than before, I though it was something of the indexes, but I rebuild them and it continues. The computer is a 4 CPU processor, 4gb in RAM, is linux Centos 5.5, is a guest machine virtualized with VMWARE. I also updated the clients to match the version.
> >
> > Any help will be appreciated.
> >
>
> Without telling us what exactly is slower we can not help you.
>
> Karol Bieniaszewski
>