[OAK-4638] Mostly async unique index (for UUIDs for example)

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Component/s: property-index, query
• Assignee: Unassigned
• Reporter: Thomas Mueller
• Created: 03/Aug/16 12:34
• Updated: 08/Oct/19 15:21
• Resolved: 25/May/18 10:02

Description

The UUID index takes a lot of space. For the UUID index, we should consider using mainly an async index. This is possible because there are two types of UUIDs: those generated in Oak, which are sure to be unique (no need to check), and those set in the application code, for example by importing packages. For older nodes, an async index is sufficient, and a synchronous index is only (temporarily) needed for imported nodes. For UUIDs, we could also change the generation algorithm if needed.

It might be possible to use a similar pattern for regular unique indexes as well: only keep the added entries of the last 24 hours (for example) in a property index, and then move entries to an async index which needs less space. That would slow down adding entries, as two indexes need to be checked.

Issue Links

• is duplicated by: OAK-6535 Synchronous Lucene Property Indexes
• is related to: OAK-6535 Synchronous Lucene Property Indexes
• is related to: OAK-6873 UserInitializer should not use hard coded QueryIndexProvider