Thanks...@Anderson
we use coreduo, 2 gb RAM, SATA HD and SuperServer FB.

* do not load details if you don't need it. query only the master table (MYCR)
  I take Name of item from Master Item every record (MYCR)
  I Take 1 record History Open Room Guest.
  But i not used JOIN SQL Statement, But i Used Facility IBCLIENTDATASET from DELPHI to related table.

Thanks..
Best Regard ALlies

--- On Mon, 2/16/09, Anderson Farias <peixedragao@...> wrote:
From: Anderson Farias <peixedragao@...>
Subject: Re: [firebird-support] Slow response on a big database?
To: firebird-support@yahoogroups.com
Date: Monday, February 16, 2009, 3:07 PM












Hi,



>what this slow response if :

>1. Load data 30 - 50 record from MYCR table (Have 50.000 record)



loading 30-50 records out ou 50K is very fast even non indexed



> 2. MYCR have a related 3 another table (1. Master Item table have 2.500

> record, 2. data

> history Open Room 35.000 record and Master Room 500 record)



do not load details if you don't need it. query only the master table (MYCR)

to list entries and when user chooses one to see details, than query for the

details for the selected record only.



(of course, if this fits your needs)



>3. 40 user client at this time

>load data need 5 sec to display 30-50 record ?



I'd say less than 1 sec to execute... But there's net traffic, and other

issues. If your server CPU (P4?) is HT either disable it of don't use SS...

Classic will perform better.



Regards,

Anderson Farias































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