What frequency do you backup/restore this database?

What firebird version? SS CS?

What your garbage policy?



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]