Technische info

Bedoeld voor Netwerk- en systeembeheerders (supervisors, administrators)

Om de stabiliteit en snelheid van uw AXITO-systeem te optimaliseren, kunt u met behulp van de Windows register-editor (regedit) een aantal instellingen aanpassen onder Windows!
Volgende tips moet u best opvolgen. (Opmerking: omdat deze tips vooral bedoeld zijn voor netwerk- en systeembeheerders, vermelden we de originele Engelstalige tekst (opgesteld in 2009), zodat geen enkele nuance verloren gaat. We gaan er van uit dat deze doelgroep weet waar ze mee bezig zijn.)

1.OP Locking & stability of the network

Absolutely necessary are:

– OP locking has to be disabled.

• Microsoft Knowledgebase-ID: Q296264

– Client: HKEY_LOCAL_MACHINE\System\CurrentControlSet\

Services\MRXSmb\Parameters\OplocksDisabled = 1

– Server: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\

Services\LanmanServer\Parameters\ EnableOplocks = 0

– Anti-Virus software must not be allowed to examine DBF/FPT/CDX/XPF files.

– Powersaving mode of the client network card has to be disabled.

– Auto-disconnet of the server has to be disabled.

• net config server /autodisconnect: -1 (Q297684)

– Do not use Vista without SP1!

2. I/O-Performance

• Typical phenomenon:

– USE of table or index file takes very long (~1s)

• HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\

LanmanServer\Parameters\SharingViolationDelay = 0 (default: 200)

• HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\

LanmanServer\Parameters\SharingViolationRetries = 0 (default: 5)

– DbAppend()/DbCommit() are very slow

• HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\

Lanmanworkstation\Parameters\DisableFlushOnCleanup = 1

• Hardware

– Good switches and routers are recommended.

Note: The latency is the limiting factor, and not the band width!

– Fast harddisks or Raid O array.

Note: rotation == transaction speed!!

3. Drawbacks of ActiveX:

– Generally, ActiveX controls require more system resources compared to a Xbase Part

– The majority of controls can not safely be used in a multithreading environment; better refrain from sharing ActiveX controls between several threads!

– Many controls are only of mediocre quality, and despite their pleasant appeal, they frequently lead to program crashes or hang-ups etc.

– Deployment and maintenance require special attention.

4. Long file names:

• Question: Which essential information of the file system does not get cached per default by the Windows operating

system?

• Answer: Long file names

• Therefore: File access will always be faster using 8.3 notation, except for InfoCacheLevel = 16 (0x10)

• Unfortunately, this setting has to be explicitly enabled:

– HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\

Services\MRxSmb\Parameters\InfoCacheLevel = 16

• Q834350 and Q843418

5. Final note

Network- and server infrastructure do significantly determine your application´s performance and stability. This holds also true for client/server-based solutions; only there might occur other problems.