[YC-731] Optimise full text search query builder for deep category hierarchies Created: 12/Jul/16  Updated: 12/Sep/17  Resolved: 13/Jul/16

Status: Closed
Project: YesCart
Component/s: None
Affects Version/s: 3.0.0, 3.1.0, 3.2.0
Fix Version/s: 3.3.0

Type: Improvement Priority: Major
Reporter: Denis Pavlov Assignee: Denis Pavlov
Resolution: Fixed Votes: 0
Labels: performance
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified


Deep category hierarchies with "search in sub categories" option result in Lucene error boolean clauses exceed 1024.

Need to optimise how we manage search in subcategories by storing full parent tree structure and then have single clause for including current category. Since we can only pass List<Longs> we can pass negative PK to indicate "search in sub categories". The challenge is to traverse the parent tree with category links included

Comment by Denis Pavlov [ 13/Jul/16 ]


Generated at Mon Feb 24 20:48:20 UTC 2020 using JIRA 7.8.0#78000-sha1:4568b9d484113d74dfb6f152fb925b5fa1be2ef7.