this case same with my application. but my application slow response if my table have 50.000 record :
� 1. Development with delphi 6 / client dataset
� 2. read / write 8 table run at this time and have 50 computer client
� 3. server with windows 2000, RAM 2 gb
� 4. every condition (Order by and Where SQL Statement) i create index
every 1 month i move all recard to backup database. my application runing fast if database after run backup/restore and have record <50,000.

so many user client ? or wrong at my application ?

thakns

--- On Mon, 2/16/09, Svein Erling Tysvaer <svein.erling.tysvaer@...> wrote:
From: Svein Erling Tysvaer <svein.erling.tysvaer@...>
Subject: Re: [firebird-support] Slow response on a big database?
To: firebird-support@yahoogroups.com
Date: Monday, February 16, 2009, 9:15 AM












Have you looked at www.firebirdfaq. org/faq13/ ? Particularly note the

second point, that's a very common reason for a database to gradually

slow down.



HTH,

Set



Mustafa �im�ek wrote:

> Hi,

>

> i have a Firebird 1.5.5 Dialect 1 database about 1.5 GB. Sometimes my

> database response very slow. i do backup & restore and everything ok

> for awhile then start slow response again. i use Delphi 6 & IBX &

> Firebird 1.5.5 dialect 1. i have primary key and necessary foreign

> keys all the tables.

>

> 1) How could i determine what is the problem and how could i solve this problem?

> 2) I use events. Events to cause this problem?

> 3) if i upgrade Firebird 2.1.1, this help solve the problem?

>

> ps. sorry my english.

>

> Best Regards.































[Non-text portions of this message have been removed]