Limit of 500 characters for the local or global node
As I understand it. The local or global indexes can contain a maximum of 500 characters. How can I go around this limitation?
Go to the original post written by @Gevorg Arutiunian
Discussion (4)2
Comments
I think you are talking about subscripts and about the full length of global reference. You can't do anything with it and just accept it as a fact.
You may take my previous article The 'unlimited' UNIQUE index as a suggestion how to work around this limit.
What a problem are you trying to solve? Is it to sort long strings? or ti find duplicates in long strings?
If you're hitting the 511 encoded character limit for a global reference, generally that means you should revisit your data design. What are you trying to do that you hit that limit?