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

>
> Hi
>
> I have identical tables in separate databases. when I run an update query on the table in one DB it takes 1 sec, on the other DB it takes 90 sec.
>
> Query
> update disc set area_code = LTrim(area_code)
>
> Table disc has approx 62000 records
> using firebird 1.5.6 on Windows XP
>
> Used IBExpert to check table data are identical & Indices are identical.
>
> Has anyone any idea why there is such a time difference .
>
> Thanks for any help
>
> Jack
>

1. record versions - use sweep on both and update index statistics
the best is do backup and restore and then check if time is the same

2. fragmentation on hard disk

Karol Bieniaszewski