Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 6 of 6 total

Mon, Jan 9 2006 10:07 PM	Permanent Link
Sanford Aranoff	The size of the idx file is 11.4 MB, and the dat file is 2.5 MB. Opening the app and loading the tables takes 6 seconds. Is this normal?
Mon, Jan 9 2006 11:08 PM	Permanent Link
Steve Forbes Team Elevate	Hi Sanford, IDX files are frequently larger than their related DAT, although an 11 to 2 ratio is bigger than I normally see. The size of a IDX depends on how many indexes you are maintaining on the table and the sizes of the individual columns in each index. Best regards Steve "Sanford Aranoff" <aranoff@analysis-knowledge.com> wrote in message news:43C32511.E1EBB7C@analysis-knowledge.com... > The size of the idx file is 11.4 MB, and the dat file is 2.5 MB. > > Opening the app and loading the tables takes 6 seconds. > > Is this normal? > >
Tue, Jan 10 2006 3:15 AM	Permanent Link
"Ralf Mimoun"	Sanford Aranoff wrote: > The size of the idx file is 11.4 MB, and the dat file is 2.5 MB. Please post the table structure, eg. the Reverse Engineering script. How many records do you have, what's the size after optimization? > Opening the app and loading the tables takes 6 seconds. What do you mean with "loading the tables"? Do you load them into memory? How many? What kind of connection: LAN, WLAN, DSL, file access or C/S? Are there any OnBeforeOpen or OnAfterOpen events causing a delay? Ralf
Tue, Jan 10 2006 7:44 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Sanford, << The size of the idx file is 11.4 MB, and the dat file is 2.5 MB. Opening the app and loading the tables takes 6 seconds. Is this normal? >> It depends upon whether you have turned on index compression, etc. As Ralf suggested, a copy of the table structure, including indexes, will be helpful in giving you more information on how to reduce the size of the indexes. -- Tim Young Elevate Software www.elevatesoft.com
Tue, Jan 10 2006 8:53 PM	Permanent Link
Sanford Aranoff	"Tim Young [Elevate Software]" wrote: > Sanford, > > << The size of the idx file is 11.4 MB, and the dat file is 2.5 MB. > > Opening the app and loading the tables takes 6 seconds. > > Is this normal? >> > > It depends upon whether you have turned on index compression, etc. As Ralf > suggested, a copy of the table structure, including indexes, will be helpful > in giving you more information on how to reduce the size of the indexes. No index compression. Now the program does not take a long time to load up!
Wed, Jan 11 2006 4:38 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Sanford, << No index compression. Now the program does not take a long time to load up! >> Are you saying that the program is loading quick now and you haven't changed anything ? If so, then it was probably just the Windows file system caching/hard drive activity. -- Tim Young Elevate Software www.elevatesoft.com