@Dimitry

>You must use tools, such as IBAnalyst,
>IBTransaction Monitor and FBScanner by ib-aid to find out what is wrong
>and fix it.

Thanks a lots...
This is solution to me... Thanks..
i just receive information from My Client's IT, They Say.. Ibconfig is Blank.. Just 1 row but this is Remark.But i am not sure about this. i must be check server comp.

> may be they cause garbage collection - no

This possible thing. because i set sweep =20000.and some one at firebird milling list command to change sweep is zero. but i am not try yet.
 

> there must be slowly executed queries

This possible things. But Every week, 3 day run many transaction from client computer. and this can handle first week and 2 day next week (Fast). but when Third Day on Second week.. starting slow down.

--- On Mon, 4/27/09, Dimitry Sibiryakov <sd@...> wrote:

From: Dimitry Sibiryakov <sd@...>
Subject: Re: [firebird-support] Still About performance and running slow
To: firebird-support@yahoogroups.com
Date: Monday, April 27, 2009, 11:16 AM

> may be you can give me some Idea to manage server datbase (like datapages
pages,cahce,sweep). database server slowdown when compluter client running many
application,

No way. You must find out exactly what "slowdown" is and it's
reason.
Server can't just "slow down", there must be slowly executed
queries.
May be they come to bad plan, may be they cause garbage collection - no
way to find it out via telepathy. You must use tools, such as IBAnalyst,
IBTransaction Monitor and FBScanner by ib-aid to find out what is wrong
and fix it. There are many things that can be wrong: from hardware
settings to DB and application design.

SY, SD.

PS: Look at the situation from different angle: you want us to solve
your problem for free to get your money from your customer. It is...
boldly, isn't it?..


------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links








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