The Btree.Write patch is a re-issue of a fix that corrects a problem which was causing certain index updates or rebuilds to take a very long time. Specifically, the slowness could occur if a long list of keys was indexed to the same index value. Null values in a field, for instance blank values in a job_complete_date_field, are a common reason for having a long list of keys indexed to the same value. A version of this btree.write fix was released with OI4.13. Researching the index corruption caused by v119 and null values caused us to revisit the btree.write logic and improve the long-list enhancement.

You must have the V119.dll posted 6/16/03 installed to use the BTree.Write patch.

The patch can be found in the Works Download section.

Revelation,

Is this patch meant to resolve the index update problem I previously gave to Mike? He confirmed the problem but thought it was possibly related to a combination of issues: 1.) Unicode, 2.) multi-part keys, and 3.) a negative effect from a fix where preceeding zeros were looked at correctly. I am skeptical if this was a Unicode issue since we confirmed the index update issue started with the first version of OI32 and never appeared in OI16.

I appreciate your response to this as our client is still asking for a resolution to this problem.

Thanks,

dbakke@srpcs.com

SRP Computer Solutions, Inc.

Don-

The btree.write and v119 fix do correct your problem.

When we were talking I said we had made the problem worse when I was debugging it because of UTF8 issues we were having at the time- and they are all resolved now.

Yours was the test files- and they now work fine, in both 4.1.3 and 7.0

Thanks-

Mike

Mike,

Sweet! I'm glad those test files were usable for something!

Thanks for pushing a solution out for this.

dbakke@srpcs.com

SRP Computer Solutions, Inc.

View this thread on the Works forum...