Subject | Slow UPDATE |
---|---|
Author | Xavier Solé |
Post date | 2003-04-23T11:23:56Z |
Hello listers,
if I have a table in my Firebird database and I add a new column to this
table (type varchar(30)), why is an update of this column so slow? For a
table with 2500 rows it takes more than 5 minutes. On the other hand, if the
new column is added when the table is already created the update takes just
a few seconds.
Thanks,
Xavi.
if I have a table in my Firebird database and I add a new column to this
table (type varchar(30)), why is an update of this column so slow? For a
table with 2500 rows it takes more than 5 minutes. On the other hand, if the
new column is added when the table is already created the update takes just
a few seconds.
Thanks,
Xavi.