> --- 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.

Could be:

* Background garbage collection (data + index)
* Automatic sweep kicking in
* Using AutoCommit/Commit Retaining without doing a hard commit from
time to time


- Is this a single client attachment/application doing the work or are
multiple attachments connecting to the database?
- Can you clarify what the update process exactly does?


Btw, SuperServer can't utilize multiple cores/CPUs for a single database.


Regards,
Thomas

>> 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]
>>
>
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>