Re: [firebird-support] How to improve update performance with millions records?

2012-06-14 Thread Milan Babuskov
firebird_jimmy wrote: 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

RE: [firebird-support] How to improve update performance with millions records?

2012-06-12 Thread Svein Erling Tysvær
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?

Re: RES: [firebird-support] How to improve update performance with millions records?

2012-06-12 Thread Thomas Steinmaurer
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

Re: RES: [firebird-support] How to improve update performance with millions records?

2012-06-12 Thread Thomas Steinmaurer
: 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

Re: RES: [firebird-support] How to improve update performance with millions records?

2012-06-12 Thread firebird_jimmy
@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

Re: RES: [firebird-support] How to improve update performance with millions records?

2012-06-12 Thread firebird_jimmy
--- In firebird-support@yahoogroups.com, Thomas Steinmaurer ts@... wrote: --- In firebird-support@yahoogroups.com, Thomas Steinmaurerts@ wrote: --- In firebird-support@yahoogroups.com, Fabianofabianoaspro@ wrote: What frequency do you backup/restore this database? This database

Re: RES: [firebird-support] How to improve update performance with millions records?

2012-06-12 Thread Thomas Steinmaurer
--- In firebird-support@yahoogroups.com, Thomas Steinmaurerts@... wrote: --- In firebird-support@yahoogroups.com, Thomas Steinmaurerts@ wrote: --- In firebird-support@yahoogroups.com, Fabianofabianoaspro@ wrote: What frequency do you backup/restore this database? This database can

RES: [firebird-support] How to improve update performance with millions records?

2012-06-11 Thread Fabiano
@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