Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-23910

High CPU utilization by the projector (need to optimize N1QL parse/evaluate)

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • 5.5.0
    • 4.5.0
    • query, secondary-index
    • None

    Description

      We need to improve the parsing capabilities of the parser used by the projector and query engine.

      Problem
      In document size over 180KB with 90 mutations per second and 20 indexes with a number of different WHERE clauses the projector can use a lot of CPU.

      Expectation
      That the projector can process data as efficiently as possible

      Work Around
      To avoid using WHERE clauses with large document and see if the same logical can be applied to the document key (meta().id).

      It worth noting that collection will help for number of usage cases like this, however there will still be time when the projector will have to parser large documents and in those cases will still hit this problem

      Attachments

        Issue Links

          Activity

            People

              mahesh.mandhare Mahesh Mandhare (Inactive)
              asif.kazi Asif Kazi (Inactive)
              Votes:
              2 Vote for this issue
              Watchers:
              24 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                PagerDuty