Hi,
As it progressively becomes better known that 255 chars is NOT the
metadata size limit:
http://tech.groups.yahoo.com/group/intradoc_users/message/17750
Did anyone do it? Noticed search performances decrease? Interested in
your experiences. Will share ours.
In our case which is probably the case of others, we don't want
all 'memo' fields to become 4,000 chars (or 1,333 in the case of UTF-8
databases) and possibly expericence 'some' degree of search
performances loss and/or wasted space. Only 1 of our memo field is
candidate.
Idea!!! For a new metadata MEMO field, would it work to change the
MemoFieldSize in config.cfg before the metadata field creation, then
create this field, which should resolve into VARCHAR2(1333) in the
docmeta table, then finally revert MemoFieldSize to the normal 255
chars. This way, the former, and upcoming MEMO stay at 255. Will try
this on DEV instance..