Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread Size of IDX
Thu, Jun 15 2006 9:01 AMPermanent Link

Sanford Aranoff
I have a table with the dat file 3000 KB, and the idx 15,000 KB. Will
the large size of the idx cause problems? Shall I make an effort to
reduce the size of the idx?

Thanks.

Thu, Jun 15 2006 9:26 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Sanford


My largest one is 125Mb and it doesn't seem to hurt. Its a mixture of field and fulltext indices . The .dat is c50Mb and the .blb c900Mb

Roy Lambert
Thu, Jun 15 2006 1:44 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Sanford,

<< I have a table with the dat file 3000 KB, and the idx 15,000 KB. Will the
large size of the idx cause problems? Shall I make an effort to
reduce the size of the idx? >>

Not really, although you may want to try turning on index compression on the
indexes if you aren't already:

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

--
Tim Young
Elevate Software
www.elevatesoft.com

Image