[ https://issues.apache.org/jira/browse/DERBY-2721?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mamta A. Satoor updated DERBY-2721:
-----------------------------------
Urgency: Normal
Labels: derby_triage10_10 (was: )
> improve performance of index lookups of string types in territory based collated databases.
> -------------------------------------------------------------------------------------------
>
> Key: DERBY-2721
> URL: https://issues.apache.org/jira/browse/DERBY-2721
> Project: Derby
> Issue Type: Improvement
> Components: SQL, Store
> Affects Versions: 10.3.1.4
> Reporter: Mike Matrigali
> Priority: Minor
> Labels: derby_triage10_10
>
> Comparison of strings in a non unicode basic collation database is going to be slower
than comparing unicode values directly. Indexes perform
> many such compares before finding a single key in a search.
> Some suggestions for future work:
> o Somehow cache CollationKey's for the strings and use them directly for compares rather
than the actual strings.
> o even better would be to use a functional index that actually stored CollationKey's
rather than the strings themselves, and then build the index on the
> CollationKeys. Depends on some sort of functional index work. Something like
DERBY-455 would build the infrastructure to make this kind of
> index easy.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
|