Walter Meester
HoogkarspelNetherlands
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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,
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only