Mailing List Archive



Back to the month index Back to the list index

Willem van den Bosch (willem@onthenet.com.au)
Mon, 6 Jan 1997 06:35:01 +1000


Message-Id: <199701052040.GAA26161@diablo.OntheNet.com.au>
From: "Willem van den Bosch" <willem@onthenet.com.au>
Date: Mon, 6 Jan 1997 06:35:01 +1000
Subject: [mSQL] Index file size

I am hoping someone can enlighten me as to the size of the IDX files
I have an index created on a CHAR(40) field which gives me an index
file which jumps from 1K without any records in the table to about
1.1 Meg when just one record is added. I have added some additional
records (only 6) without any increase in the index file size.

As this question is born out of ignorance, Any explanation would be
greatly appreciated.

Regards Willem

+--Willem van den Bosch ---------------------------------------+
| OzArtNet |
| Australian Art On-Line http://www.ozartnet.com.au |
+--Phone: +61 7 5533 5260 ----- Fax: +61 7 5533 5371 ----------+
--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!