Subject | Re: [firebird-support] Slow response on a big database? |
---|---|
Author | Mustafa Şimşek |
Post date | 2009-02-16T13:17:19Z |
Hi,
thanks for quick answer. This is the my biggest database so i said big
db... you are right, it' not so big.
i use SuperServer. my server P4 3.0, 1 GB Ram PC, Windows XP SP2.
i read/write 6-7 table this time. 2 Master table have 150.000 and
700.000 records. Details tables have about 1.500.000 and 2.500.000...
i have 4 events. i have a form on delphi side, when i receive this
events i update this form.
i don't know what transaction is slow exactly. i perform several tasks
this time. Speed is good after backup-restore for a while. The speed
gets slow and going slow on.
Best Regards.
On Mon, Feb 16, 2009 at 2:38 PM, Anderson Farias
<peixedragao@...> wrote:
thanks for quick answer. This is the my biggest database so i said big
db... you are right, it' not so big.
i use SuperServer. my server P4 3.0, 1 GB Ram PC, Windows XP SP2.
i read/write 6-7 table this time. 2 Master table have 150.000 and
700.000 records. Details tables have about 1.500.000 and 2.500.000...
i have 4 events. i have a form on delphi side, when i receive this
events i update this form.
i don't know what transaction is slow exactly. i perform several tasks
this time. Speed is good after backup-restore for a while. The speed
gets slow and going slow on.
Best Regards.
On Mon, Feb 16, 2009 at 2:38 PM, Anderson Farias
<peixedragao@...> wrote:
>> i have a Firebird 1.5.5 Dialect 1 database about 1.5 GB.
>
> BTW, 1.5Gb database is *not* actually "big"
>
> =)
>
> Regards,
> Anderson Farias
>
>