>>ITEM: N00104
>>DATE: August 16, 1996
>>TYPE: Information
>>TITLE: TTS slow with Netware 3.x or later
>>PRODUCT(S):
NetLib (all versions) for Clipper
NetLib (all versions) for FoxPro DOS
NetLib (all versions) for FoxPro Windows
>>PLATFORM(S):
Netware 3.x or later with TTS enabled
>>SUMMARY:
Tips for improving TTS performance when using explicit
transaction tracking with NetLib.
>>MORE INFORMATION:
>>RESOLUTION/FIX:
Novell has made several changes in Netware 3.x and 4.x that
improve TTS reliability, but may impact performance unfavorably. If your application is running intolerably slow, you can improve performance with these two server SET commands
SET DIRTY DISK CACHE DELAY TIME=nn (default = 3.3 seconds)
This tells Netware how long after an update to flush cache memory to disk. It can be set from 0.1 to 10 seconds, with
the default being 3.3 seconds. Setting this to a lower value
will speed up transactions, but may impede overall network
performance, since the server performs more disk I/O.
SET NCP FILE COMMIT ON|OFF (default = ON)
By specifying ON, you tell Netware to immediately flush its cache buffers to disk when the program issues a COMMIT. (This did not happen
under earlier versions of Netware.) Setting this OFF will improve
performance, but *may* jeopardize rollback in the event of a
hard server crash.
>>EXAMPLE(S):
SET NCP FILE COMMIT OFF SET DIRTY DISK CACHE DELAY TIME=0.5
>>SEE ALSO:
See the Netware System Administration manual for more information
on SET parameters.
>>COPYRIGHT 1997 Communication Horizons
All rights reserved worldwide.
No distribution without specific consent of publisher.
Knowledgebase
Top Home