firebird_jimmy wrote:

> Hi, I'm jimmy
> I have a problem, please help me!
> I have a table with 3,000,000 rows record, every row update 1 to 5 times in one day. The speed of update statement become slowly, about 30 records/second, but insert speed above 1000 records/second.
> Is my usage be bad or not?
> what should i do?

Any foreign keys, triggers, secondary indexes or check constraints
involving computed fields?

--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================