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
below:
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
during
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
value
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
locked
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
hash
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
default
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.
