LS

When creating tables the following is default

INDEX PAGE SIZE 4096
BLOB BLOCK SIZE 512
MAX ROW BUFFER SIZE 32768
MAX INDEX BUFFER SIZE 65536
MAX BLOB BUFFER SIZE 32768

Is there a way to determine what the best values would be? Is there some
info on each of the above?

Regards, Harry

Harry,

<< Is there a way to determine what the best values would be? Is there some
info on each of the above? >>

The best values are the defaults.  Only if you run into performance issues
should you increase the buffer sizes, and then only by 32k-64k at a time.
Having too much buffer space can be just as bad as having too little.

As for the index page size, the only time you'll need to increase the index
page size is if you have a very large index column and it is too big to fit
on the existing index page size.

The BLOB block size should be increased if you're storing very large BLOBs
in the table.  For example, if you're storing 2-10 meg (or higher) BLOBs in
your table, then you should increase the BLOB block size to at least 8k or
higher

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

> As for the index page size, the only time you'll need to increase the
index
> page size is if you have a very large index column and it is too big to
fit
> on the existing index page size.
How do I know how large the index column is (how to calculate this)?

Regards, Harry


"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> schreef in bericht
news:CCF1BB88-0407-4465-960C-0F50FDE90581@news.elevatesoft.com...
> Harry,
>
> << Is there a way to determine what the best values would be? Is there
some
> info on each of the above? >>
>
> The best values are the defaults.  Only if you run into performance issues
> should you increase the buffer sizes, and then only by 32k-64k at a time.
> Having too much buffer space can be just as bad as having too little.
>
> As for the index page size, the only time you'll need to increase the
index
> page size is if you have a very large index column and it is too big to
fit
> on the existing index page size.
>
> The BLOB block size should be increased if you're storing very large BLOBs
> in the table.  For example, if you're storing 2-10 meg (or higher) BLOBs
in
> your table, then you should increase the BLOB block size to at least 8k or
> higher
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>
>

Harry,

<< How do I know how large the index column is (how to calculate this)? >>

You don't need to calculate it - if the index page size is too small when
you create/alter a table or create an index, EDB will issue an exception and
tell you what the required page size should be in the error message.

--
Tim Young
Elevate Software
www.elevatesoft.com