Kbase 16075: Improve Performance, preformat/grow your .bi file ( bigrow )
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
Improve Performance, preformat/grow your .bi file ( bigrow )
Improve Performance by preformatting/growing your .bi file ( bigrow )
----------------------------------------------------------------------
The before image file grows as needed through daily transactions. The
problem is that all transactions must wait while the before image file
is growing and formatting blocks.
If you allow the .bi file to mature, and don't truncate it, then you
will not see these performance pauses. However, if you need to
truncate your bi, then you may experience these pauses again until the
bi file matures. (this is true even in fixed length bi extents if you
are changing the -biblocksize within the fixed extents)
To get around this problem you can preformat, or grow, your bi file in
advance.
Version 7.3E and 8.+
--------------------
you can use this new utility -> proutil dbname -C bigrow <number>
<number> = number of clusters above the initial 4 clusters
(so the <number> + 4 * <the size of cluster> = bytes of growth>
example: proutil dbname -C bigrow 6 will be 10 clusters of growth
Prior to Version 7.3E and 8.+
-----------------------------
In prior versions you need to start a server, start a client that
begins a transaction, then have other clients performing updates.
Eventually the bi file will grow because the first client with a
transaction open will not let the bi clusters get reused.
RVE - revised 8/21/97
Progress Software Technical Support Note # 16075