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

Significant amount of time spent in GeoJSON's s2.Decode(..) during query time

    XMLWordPrintable

Details

    • 1

    Description

      As the following profile shows, GeoShape queries can spend a significant amount of time within GeoJSON's s2 Decode method based on the indexed number of coordinates (vertices) that build the geo shape.

      An improvement could be to possibly pre-determine the region encompassed by the geo shape during index time as opposed to doing this during query time. Further investigation needed here.

      Attachments

        1. run-cpu-fts1.pprof
          8 kB
          Abhi Dangeti
        2. run-cpu-fts2.pprof
          7 kB
          Abhi Dangeti
        3. run-cpu-fts3.pprof
          10 kB
          Abhi Dangeti
        4. Screen Shot 2022-10-13 at 1.02.28 PM.png
          113 kB
          Abhi Dangeti
        5. Screenshot 2023-08-28 at 3.01.38 PM.png
          308 kB
          Likith B
        6. Screenshot 2023-08-28 at 3.03.37 PM.png
          307 kB
          Likith B
        7. Screenshot 2023-08-28 at 3.04.06 PM.png
          292 kB
          Likith B
        For Gerrit Dashboard: MB-54131
        # Subject Branch Project Status CR V

        Activity

          People

            devansh.srivastava Devansh Srivastava
            abhinav Abhi Dangeti
            Votes:
            0 Vote for this issue
            Watchers:
            9 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty