--- In firebird-support@yahoogroups.com, "Fabiano" <fabianoaspro@...> wrote:

>
> What frequency do you backup/restore this database?
> This database can not stop, It used to realtime collect data.

so no restore only backup, backup it once a week.

> What firebird version? SS CS?
> FB2.5 SS, i use FB2.1 SS to test，same result.

OS is win XP, change to Win 2008 Server, same result.

> What your garbage policy?
> Sweep interval = 200 to 20000, when sweeper run, the update speed

become more slowly than normal.

>
>
> De: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] Em nome de firebird_jimmy
> Enviada em: segunda-feira, 11 de junho de 2012 10:01
> Para: firebird-support@yahoogroups.com
> Assunto: [firebird-support] How to improve update performance with millions
> records?
>
>
>
>
>
> 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?
>
> thanks!
>
> 20120610
>
>
>
>
>
> [Non-text portions of this message have been removed]
>