Specifications

13

NameIndexing(DBCFG.INI)
Nameindexingshouldbeenabledonalldatabasesespeciallythosewithover1000endpointsorusers.Itwill
benoticeablyfasterandimproveperformance.

Todothis,createabasictextfilecalledDBCFG.INI;fileandcopyittotheSBDATAfolder(assumingdefault
locationforObjectDirectory)andeditasbel
ow:


Warnings
• DonotuseSingleFilemodeasshownintheoptionsbelow.Itcanbeusedforsmalldatabasesbutnot
recommendedasitcanbemuchslower.
• TheFindfunctiondoesnotusethenamecacheandthereforesearchesthecompletedatabase
sequentially.

DBCFG.INI
Sectionsareaddeddefinedby[]withtheoptionsineachsectionaddedasbelow.
[NameIndex]
Enabled=Yes
Thismustbesetto"Yes"forthenameindex/cachingtobeusedbyprogramsrunningforthisdirectory.
LockTimeout=3000
Thisoptioncontrolshowlongtheprocesswillretryaccesstotheindexfileifitislocked.Youcandecreasethis
valueiftheadministratorexperienceslongwaitingtimesdurin
ginstallation,forexample–1000,however,
onlyindatabasessmallerthan5000systems,otherwiseyoufindthenumberbymultiplyingthenumberof
usersorsystemsinthedatabaseby0.6.

Example:Ifthenumberofusersinthedatabaseis10,000,theLocktimeoutshouldbe6000.
Thedefaultval
ueis3000.
Thevalueisin100thsofasecond.
Incaseofmultipleservers,thetimeoutcanexceedduetomanysimultaneousconnections.Inthatcasethe
valueneedstobeincreasedto30000.

LockSleep=10
Thisoptioncontrolshowlongtheprocesswillsleep(wait)beforere‐tryingopeningalo
ckedfile.Thevalueisin
1000thsofasecond.Incaseofmultipleservers,thelocksleepmightneedtobeincreasedduetomanylock
timeouts.Inthatcasethevalueneedstobeincreasedto100oreven1000.

HashCount=16
Thisoptioncontrolshowmany"buckets"thehas
hofthenameissplitinto.Itshouldbebetween1and256
(default16).Generally,agoodvaluecanbecalculatedbytakingthesquarerootofthenumberofusers.
However,foroptimalperformancethisvalueshouldbetunedbytesting.

MinEntrySize=16

Thisistheminimumspacetoallocateperobjectnameintheindexfile.Thedefa
ultof16isagoodvalueifthe
namesdonotexceed16characters.Youdonotneedtospecifythevalueifthenamesdonotexceed16
characters.
