Vantage 8 - idxbuild -TB

Yahoo Archive
1
In short, it is only a temporary value for that one action of rebuilding the
indexes.



Speed Sort (-TB)

Operating system and syntax

UNIX
Windows

-TB blocksize

blocksize
The block size in kilobytes, to allocate when sorting records for reports and
when rebuilding indexes. The default block size is 2K but can be reset anywhere
from 1KB to 31KB.

Use Speed Sort (-TB) primarily to improve sort performance, particularly during
index rebuild operations. If you increase the block size beyond 2KB, Progress
sorts records faster but uses more memory and disk space in the process. If
system memory is severely limited, you might actually choose to lower the block
size.

Sort space is allocated in the SRT file, a temporary session file having a
system-generated unique name with the prefix srt. Progress uses the SRT file to
store session-compile modules and as temporary work space during sorting
(including rebuilding indexes). Use -TB to set the SRT file block size-the
increments by which the SRT file grows.

In summary, increase -TB to at least 8 to improve index rebuild operations by 15
percent or more. Or, decrease -TB to 1 to relieve severe Windows memory
shortages during sort operations. See also the description of the Merge Number
(-TM) startup parameter.


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Dunn, Nancy
Sent: Monday, August 11, 2008 1:26 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage 8 - idxbuild -TB

In the command:
proutil mfgsys -C idxbuild -TB 32 -TM 32 -cpinternal UTF-8

Does the 32 stand for the block size?
If I am using the line "Schema area":6,64 in my mfgsys.st file wouldn't I need
to change 32 to 64?

Thanks
Nancy



[Non-text portions of this message have been removed]


------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
2
In the command:
proutil mfgsys -C idxbuild -TB 32 -TM 32 -cpinternal UTF-8

Does the 32 stand for the block size?
If I am using the line "Schema area":6,64 in my mfgsys.st file wouldn't I need to change 32 to 64?

Thanks
Nancy



[Non-text portions of this message have been removed]