[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


 Description   

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



 Comments   
Comment by Denis Pavlov [ 13/Jul/16 ]

https://github.com/inspire-software/yes-cart/commit/5c1fcc20c18cb7cd62e73634e8fce1d194ddb1bd

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