Uploaded image for project: 'YesCart'
  1. YesCart
  2. YC-471

Optimise full text query performance

    Details

      Description

      There is some duplication with respect to categories in filters that produce queries with redundant clauses:

      ((+productCategory.category:3) +(attribute.attribute:1120^2.0 sku.attribute.attribute:1120^2.0) +(attribute.val:1120Half-Height SATA DVD-ROM^3.5 sku.attribute.val:1120Half-Height SATA DVD-ROM^3.5)) +(+productCategory.category:3)

      ((+(+productCategory.category:3) +(attribute.attribute:1120^2.0 sku.attribute.attribute:1120^2.0) +(attribute.val:1120Half-Height SATA DVD-ROM JackBlack^3.5 sku.attribute.val:1120Half-Height SATA DVD-ROM JackBlack^3.5)) +((+productCategory.category:3 +sku.skuPrice:[00000010_EUR_00150000 TO 00000010_EUR_00200000]))) +(+productCategory.category:3)

      Need to optimise query builder interface

        Attachments

          Activity

            People

            • Assignee:
              denis Denis Pavlov
              Reporter:
              denis Denis Pavlov
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: