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

Forgot to mention, when things are slow, run:

gstat -r -i <yourdatabase>


Feel free to send the output to:

t . steinmaurer AT upscene . com (remove/adjust the obvious things *g*)


for further inspection.


--
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist

http://www.upscene.com/

Do you care about the future of Firebird? Join the Firebird Foundation:
http://www.firebirdsql.org/en/firebird-foundation/

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