thanks... and Great Skill for you @indYsoft...
i have 4 table with 50.000 record and every table have 15-20 field.
and my application always refresh every 10 second (every user client) to check new Order sales from another client.

I dont used JOIN SQL statement, but i use related table with IBCLIENTDATASET from Delphi. but i used WHERE and ORDER BY SQL Statment at my IBCLIENTDATASET.
5 table always open, and 4 table open/close.

for next Project Application, must be run/use/handle for 80 client at 18 floor.

so confused if my applicati9on can not handled..

Thanks for everything and sorry my english... PISS

--- On Mon, 2/16/09, Indysoft Bt. <indysoft.hu@...> wrote:
From: Indysoft Bt. <indysoft.hu@...>
Subject: Re: [firebird-support] Slow response on a big database?
To: firebird-support@yahoogroups.com
Date: Monday, February 16, 2009, 11:42 AM

Hi!

Based on my experiences the most possible reason is the implicit
transaction handling of the data access layers. The COMMIT_RETAINING
with long lasting transactions kills the server. I use explicit TR
handling and everything is OK. With so many clients/connections, the
server is running very fast with bigger databases. OK, it is not too
much records, but I have a table with GEOIP information (IP address
ranges mapped to their respective geographical location, with
longitude/latitude coordinates, ISP, COUNTRY, CITY information from the
whole world). It contains 4.500.000 records and runs very fast with many
clients connected. I also made a load test with a database, there is a
table contains 50.000.000 records with INTEGER, VARCHAR,DATE, etc
fields. It is also very fast with this amount of data, with so many
client requests. Explicit TR handling is the key, in my opinion.


Regards:Alex :-)


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

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

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]