Hi,

I have a question on the below buffer sizes and there value. When is it applicible to increase these? will I see any speed benefit?
e.g if I have a table with 500,000 row in it or more?

MAX ROW BUFFER SIZE <MaxRowBufferSize>
MAX INDEX BUFFER SIZE <MaxIndexBufferSize>

Is the default size ok, or do you have any recomendations?

Thanks

Graeme

Graeme,

<< I have a question on the below buffer sizes and there value. When is it
applicible to increase these? will I see any speed benefit?  e.g if I have a
table with 500,000 row in it or more? >>

If you're using C/S, then the default buffer sizes should be fine.  However,
as the row size increases, it may be to your benefit to increase the buffer
sizes a bit.  The default buffer sizes were based on an average row size of
a few hundred bytes, so if your row size is over 1k and heading towards 2k,
then you may want to double the row buffer size.

--
Tim Young
Elevate Software
www.elevatesoft.com