When browsing the network through windows explorer/DOS everything is very fast and slick however when we run fox pro programs that access fox pro DB they hang or are slow when closing a DB. We have a program which up into the other day ran fine. This program just sits on a machine looking in a file for any new orders then prints the labels for that order. So this opens a couple of DB and spools the label to the printer and prints however many labels are needed. The printing bit is fine but when the machine closes the DB it takes quite a long time. Has anyone any ideas of speeding this up.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Fox Pro DB
- Thread starter tcstudio
- Start date
Tell us more - what version of NetWare are you running, what Service Packs, what OS on your workstation etc.... -----------------------------------------------------
"It's true, its damn true!"
-----------------------------------------------------
"It's true, its damn true!"
-----------------------------------------------------
- Thread starter
- #3
First thing to try would be to update the Novell Client to v3.32 as 1998 seems a bit old. Can be found at
Is your workstation a high-spec PC with enough memory? I was just surmising whether the performance of the machine may be causing your issue (page file / memory etc...) -----------------------------------------------------
"It's true, its damn true!"
-----------------------------------------------------
Is your workstation a high-spec PC with enough memory? I was just surmising whether the performance of the machine may be causing your issue (page file / memory etc...) -----------------------------------------------------
"It's true, its damn true!"
-----------------------------------------------------
We sped this up by turning on opertunistic locking. When a test operation was done turning on op-locks reduced the network I/O from 2 GB to 20 MB and reduced the time from 2 hours to 20 minutes. Check and make sure the change is not going to disrupt other things though, especially DOS apps.
The Novell client installs with this option turned off. There must be a reason.
The Novell client installs with this option turned off. There must be a reason.
On NetWare 5.0 SP6a or 5.1 SP3 you can set the oppertunistic file locking at the server:
SET CLIENT FILE CACHINE ENABLED = OFF
It tends to help a lot.... in my experience! -----------------------------------------------------
"It's true, its damn true!"
-----------------------------------------------------
SET CLIENT FILE CACHINE ENABLED = OFF
It tends to help a lot.... in my experience! -----------------------------------------------------
"It's true, its damn true!"
-----------------------------------------------------
TheBoySmith
Technical User
Is the foxpro database on a traditional netware volume or nss volume?
Had a massive problem running on nss and had to move to a traditional and all ran perfect. Lee Smith
Associated Network Services
Snr Systems Engineer
Lee.Smith@ANSPLC.Com
Had a massive problem running on nss and had to move to a traditional and all ran perfect. Lee Smith
Associated Network Services
Snr Systems Engineer
Lee.Smith@ANSPLC.Com
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question