Uploaded image for project: 'Data Management'
  1. Data Management
  2. DM-529

Investigate utility of scisql + HTM indexing for region searches in Qserv

    XMLWordPrintable

    Details

    • Type: Story
    • Status: To Do
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: Qserv
    • Labels:
      None
    • Team:
      Data Access and Database

      Description

      It might be advantageous to use scisql support for fast point-in-region searches when executing point-in-polygon (and similar) searches via Qserv.

      Since Qserv already limits the execution of such queries to just those chunks overlapping the search region, it may not be worth doing this (unless chunks are really large).

      This very low priority issue corresponds to ticket 2056 from Trac, and serves as a reminder that we should do some performance testing to figure out whether to pursue this potential optimization or not. In particular, testing performance on a 1 million row chunk that is 60-80% covered has been suggested.

        Attachments

          Issue Links

            Activity

            Hide
            gpdf Gregory Dubois-Felsmann added a comment -

            Ping. Is this still a relevant issue?

            Show
            gpdf Gregory Dubois-Felsmann added a comment - Ping. Is this still a relevant issue?
            Hide
            fritzm Fritz Mueller added a comment -

            Still relevant, but low priority.

            Show
            fritzm Fritz Mueller added a comment - Still relevant, but low priority.

              People

              Assignee:
              smonkewitz Serge Monkewitz
              Reporter:
              smonkewitz Serge Monkewitz
              Watchers:
              Fritz Mueller, Gregory Dubois-Felsmann, Serge Monkewitz
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:

                  Jenkins

                  No builds found.