| Subject | About update clause's time. |
|---|---|
| Author | Yang Jin |
| Post date | 2005-08-19T11:59:08Z |
hello,
I update 27,000 records in a table with 300,000 records.I use primary key as only where condition, the whole execute time almost 2mins.If I update all records, the time is almost 6m.
The database is dialect 3,the page size is 16K,ODS is 10.1, Execute update clause in IBExpert, Firebird1.52 as service.
I want to know if the time can short.I hoep result is less 30 sec.
TIA.
---------------------------------
DO YOU YAHOO!?
雅虎免费G邮箱－No.1的防毒防垃圾超大邮箱
[Non-text portions of this message have been removed]
I update 27,000 records in a table with 300,000 records.I use primary key as only where condition, the whole execute time almost 2mins.If I update all records, the time is almost 6m.
The database is dialect 3,the page size is 16K,ODS is 10.1, Execute update clause in IBExpert, Firebird1.52 as service.
I want to know if the time can short.I hoep result is less 30 sec.
TIA.
---------------------------------
DO YOU YAHOO!?
雅虎免费G邮箱－No.1的防毒防垃圾超大邮箱
[Non-text portions of this message have been removed]