Hi John,

Happy new year,

>Hi,
> I am developing multiuser application now.
> I am running my application under 10BASET erthernet LAN. CYRIX MII 300 64MB
RAM server.
> My table contains 10000 reocrds. When I tried to pull out 5000 records from
server, it take me 1-2 minutes. Therefore, I tried to change my network card to 100BASET. It work faster, about 4 seconds for 5000 records.

This seems quite bad. How large is the table (MB) ? Which indexes did you use ? When retrieving the 5000 records which indexes are used to optimize ? Did you try setting optimization off ?

> Is it acceptable for this performance? Any way to imrpove it again?

4 seconds, for 5000 records is not that bad, however 1-2 minutes on a 10BASET is bad, very bad. How is network trafic ?

Walter,