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