--- In firebird-support@yahoogroups.com, Svein Erling Tysv�r <svein.erling.tysvaer@...> wrote:

>
> >Hi, I'm jimmy
>
> Hi 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?
>
> I don't know whether your usage is bad or not. What kind of indexes do you have and how do you update? What about transactions, do you have a noticeable gap between oldest (active) transaction and next transaction? I don't know whether it is still relevant (it is a very old article), but in some cases I think rdb$db_key can be useful for updates: http://ibexpert.net/ibe/index.php?n=Doc.TheMysteryOfRDBDBKEY
>
> HTH,
> Set
>

> Thanks your help!
> My table have a primary key with integer, when update 200 rows then commit trans. th