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

>
>
> --- In firebird-support@yahoogroups.com, "karolbieniaszewski" <liviuslivius@> wrote:
> >
> >
> > --- 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
> >
>
> Hi Karol
>
> Thanks for the response.
> 1. Did backup & restore, updated index statistics no change still approx 90 sec to update.
>
> 2. Defragged the hard drive & update increased to approx 200 sec.
>
> seems to be associated with hard disk access?
>
> Jack
>

To test this try create empty partition and there put this restored databases

How long now?
If long
Copy once again databases after restore process
and try deactivate all indexes on this tables
how long now?

Karol Bieniaszewski