Dan Wilson wrote:

> It is my understanding that Firebird 2 will relax the current restriction on length of index fields, which would indeed solve the compatibility problem. However, I have to believe that performance of the ofbiz product would be greatly improved by redesign of the data model to make use of integer or int64 id fields. I cringe at the thought of doing table scans and having to compare multiple large varchar fields for each and every row.

That is the point I have been making. TikiWiki was exactly the same, but
TikiPro does not suffer from that bloat. With TikiWiki I was able simply
to drop indexes, and trim a few field sizes to get a working Firebird
database. Would the same work with ofbiz in the short term?

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services