Uploaded image for project: 'Apache AsterixDB'
  1. Apache AsterixDB
  2. ASTERIXDB-2310

Use Primary Key Index to Enforce Insert Key Uniqueness

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Implemented
    • Affects Version/s: None
    • Fix Version/s: None
    • Labels:

      Description

      **Currently when ingesting data using INSERT operations, we always check the primary index to ensure key uniqueness. However, this implies in most cases all ingested records might be accessed, which will slow down the ingestion performance a lot when the records cannot be cached. To handle this, we can enforce key uniqueness by checking the primary key index, which is much smaller and can be more easily cached.

        Attachments

          Activity

            People

            • Assignee:
              luochen01 Chen Luo
              Reporter:
              luochen01 Chen Luo
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: