I am testing the Kirix Strata for 64-bit Windows version (Kirix Strata 4.5.4.2056 (64-bit)) on Windows 8.1. The project that I am using was generated under the 32-bit Windows version originally so relationships and indexes already exist. Currently, every time that I create a new relationship ALL the previous relationship indexes are generated again! Looking at the Indexes for one of the tables each Index has the same fields but duplicated once for each time any other relationship has been changed.
For instance the "child" file BillingDocumentItem has two fields in the relationship DocumentConditionNumber and BillingItemNumber. After updating other relationships to other files four times there are now four Indexes associated with BillingDocumentItem. The first has Index Fields of DocumentConditionNumber and BillingItemNumber. The second has Index Fields of DocumentConditionNumber, BillingItemNumber, DocumentConditionNumber and BillingItemNumber! The third has Index Fields of DocumentConditionNumber, BillingItemNumber, DocumentConditionNumber, BillingItemNumber, DocumentConditionNumber and BillingItemNumber! The fourth has Index Fields of DocumentConditionNumber, BillingItemNumber, DocumentConditionNumber, BillingItemNumber, DocumentConditionNumber, BillingItemNumber, DocumentConditionNumber and BillingItemNumber!
This might not be so bad, but the BillingDocumentItem file has over 173,000,000 records!
Kirix Support Forums
Index Being Created Multiple Times
1 post
• Page 1 of 1
- MEB
- Registered User
- Posts: 13
- Joined: Wed Nov 12, 2008 3:46 pm
1 post
· Page 1 of 1
Return to Bug Reports & Suggestions