Tim

I have some doubt about index compression:
As a general rule or I use index compression in ALL indexes or I don´t use
compression.

My doubts:
1) The process of create the index will be slower with compression ?
2) The process of update the index (during a post or update) will be slower
with compression ?
3) Browsing records will be slower using compression ?
4) As I told before, is it better use compression to ALL indexes or don´t
use compression ?

Eduardo

Eduardo,

<< 1) The process of create the index will be slower with compression ? >>

Normally, no - the compression will reduce the necessary I/O to the point
that the additional CPU time required for the compression is less than the
I/O time saved.  This is all dependent upon using the guidelines here to
properly choose the correct type of index compression:

http://www.elevatesoft.com/dbisam4d5_index_compression.htm

<< 2) The process of update the index (during a post or update) will be
slower with compression ? >>

In terms of actual CPU time, yes.  However, in aggregate you should be
saving a lot more time in terms of I/O time required.

<< 3) Browsing records will be slower using compression ? >>

Same as updating above - there is a trade-off.

<< 4) As I told before, is it better use compression to ALL indexes or don´t
use compression ? >>

It is best to use the guidelines I linked to above to set the index
compression.

--
Tim Young
Elevate Software
www.elevatesoft.com