Max length of indexed values (OpenInsight Specific)
At 18 JAN 2001 07:48:52AM Oystein Reigem wrote:
What is the maximum length of indexed values in LH tables? I seem to remember there was a limit, but trying now with values of lengths up to 100 I don't seem to have any problems.
Or perhaps the limit I think of had to do with sorting - how many characters sort values could have, or how many characters would actually be sorted. But since indexes usually are sorted on value a limit on sorting would have consequences for indexes.
- Oystein -
At 18 JAN 2001 08:05AM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
You're probably thinking of the fact that the dictionary item defining the indexed file's key had to be longer than the longest key value - although we can see that an indexed value longer than the length of an indexed node (1K by default) might be a problem).
World Leaders in all things RevSoft
At 18 JAN 2001 09:19AM Oystein Reigem wrote:
Sprezzatura
You're probably thinking of the fact that the dictionary item defining the indexed file's key had to be longer than the longest key value
Am I? Please explain why.
Let's say my table's called TEST1, the key is NOKKEL and the indexed field FELT1. Are you talking about DICT.TEST1*NOKKEL???
- although we can see that an indexed value longer than the length of an indexed node (1K by default) might be a problem).
Sure. But what about not the content, but the keys of the index nodes? Some of these nodes have keys of the form *n*. Is there a length limit on these index node keys? In my experiments 100 char values seem to work fine also in these keys.
- Oystein -