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