> >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 m
>>> 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
--- In firebird-support@yahoogroups.com, Svein Erling Tysv�r
wrote:
>
> >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
> --- In firebird-support@yahoogroups.com, "Fabiano" 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
>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
--- In firebird-support@yahoogroups.com, "Fabiano" 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 tes
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@yah
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
Hi Vlad,
The issue occurred again, but, unfortunately, we only obtained a full dump. The
full dump is 8GB (1GB zipped). Would this be useful to send to you? Please let
me know so that I can put it on an ftp site for you to download. Unfortunately,
we did not obtain a mini-dump.
Regards,
Anthon
Afternoon ehaerim,
On 09/06/12 02:16, ehaerim wrote:
> thx it works again!
>
> but when it comes to INTEGER or SMALLINT type, it won't work again.
> for example,
It seems, unfortunately, that the set width command only affects
character columns. I've done a few tests with other data types and it
Hi Marc,
> I'm using Firebird 2.5.1 SuperServer on windows 7 from a .Net application
> that uses the .Net Ado Provider 2.5.2. The firebird server and the
> application run on the same machine.
>
> In order to test a component from the application, I create 100 threads that
> will read, update,
Hi everybody,
I'm using Firebird 2.5.1 SuperServer on windows 7 from a .Net application that
uses the .Net Ado Provider 2.5.2. The firebird server and the application run
on the same machine.
In order to test a component from the application, I create 100 threads that
will read, update, insert
12 matches
Mail list logo
