delphi paradox running slow on novell

[roni0401]

I am at my wit's end. I have a application that runs beautifully standalone. When we put it on the network it all went downhill.

The progam runs extremely slow. It evetually locks up. I have to delete the lock files and start again. Even then it still runs slow. I have searched every board and can't find any other fixes.

Please help!!!

Facts:
a) Application written in Delphi
b) Novell Netware 6 with latest patches
c) Paradox 9
d) All workstations are WIN 2000
e) Opportunistic locking turned off on all stations
f) All stations have c:\priv directory for temp files
g) The application exe is kept on each station
h) Data is on server
i) All stations use the same path
j) Local Share is true on workstations
k) File handles is 100 on stations
l) The servers Receive Buffer Packet Size is 50000
m) All of the nic cards are 100 mps
n) 10 users all with administrative rights

 

[footpad]

roni0401,

It certainly sounds like you've checked the environmental factors. One wonders, though, if you've checked the application's basic design. After all, it's possible to design an application that runs beautifully when run standalone, but bogs down when copied to a network.

One big factor lies in the way to access the data. If, for example, you start by running a select * query against an unkeyed table, that can lead to a huge delay as the entire dataset is transmitted to the client.

Make sure you're using primary keys, secondary indexes, and index-based approaches (setRange, etc) as often as possible. This can reduce time as it bypasses sorting the results.

Given that you only have ten users, I'd start looking in these directions. You should be enjoying much better performance, so I can only guess that there's something in the application that's not ideal for a network environment.

If you can give us an idea of the design, that may help.

Hope this does...

-- Lance