Matheus Bombonato
06/13/2025, 12:24 PMFanis Tharropoulos
06/13/2025, 1:00 PMMatheus Bombonato
06/13/2025, 1:09 PMFanis Tharropoulos
06/13/2025, 1:15 PMMatheus Bombonato
06/13/2025, 1:23 PMMatheus Bombonato
06/13/2025, 1:24 PMMatheus Bombonato
06/13/2025, 1:24 PMFanis Tharropoulos
06/13/2025, 1:25 PMMatheus Bombonato
06/13/2025, 1:28 PMMatheus Bombonato
06/13/2025, 7:48 PM{
"searches": [
{
"collection": "v3_skus",
"q": "*",
"group_by": "product_id",
"group_limit": 99,
"include_fields": "product_id,sku_id,seller_id,sku_name,product_name",
"facet_by": "brand_facet,category_facet",
"filter_by": "( (seller_id:66a9981f9e6d8686ba64a3f3) || (seller_id:6710ec596dd49c5db66804a4) || (seller_id:67d345ee0fb810922965009c && attribute_business:['Company Health','Company Health Medicine','Company','Essential Home']) || (seller_id:67d345b76a00b7b0951b4a71 && attribute_business:['Company Health Medicine','Company Health','Company','Essential Home']) || (seller_id:67d344896a00b7b0951b4a6f && attribute_business:['Company Health Medicine','Company','Company Health','Essential Home']) || (seller_id:67d36ab80fb81092296500b8 && attribute_business:['Company Health Medicine','Company Health','Company','Essential Home']) || (seller_id:67d36ae40fb81092296500ba && attribute_business:['Company Health Medicine','Company','Company Health','Essential Home']) || (seller_id:670972463814f3334d650c74 && attribute_business:['Company Health']) || (seller_id:670972463814f3334d650c74 && attribute_business:['Company']) || (seller_id:670972463814f3334d650c74 && attribute_business:['Company Health Medicine']) || (seller_id:670972463814f3334d650c74 && attribute_business:['Essential Home']) ) && $v5_offers(paymentFormId:!'null' && ((seller_id:66a9981f9e6d8686ba64a3f3 && clusters:['null']) || (seller_id:6710ec596dd49c5db66804a4 && clusters:['null']) || (seller_id:67d345ee0fb810922965009c && clusters:['null']) || (seller_id:67d345b76a00b7b0951b4a71 && clusters:['null']) || (seller_id:67d344896a00b7b0951b4a6f && clusters:['null']) || (seller_id:67d36ab80fb81092296500b8 && clusters:['null']) || (seller_id:67d36ae40fb81092296500ba && clusters:['null']) || (seller_id:670972463814f3334d650c74 && clusters:['null']))) && seller_active:true && sku_active:true && category_active:true && brand_active:true && availableToShowroom:true",
"sort_by": "_eval([(available:true):-1, (seller_id:66a9981f9e6d8686ba64a3f3):200000, (seller_id:6710ec596dd49c5db66804a4):300000, (seller_id:67d345ee0fb810922965009c):700000, (seller_id:67d345b76a00b7b0951b4a71):800000, (seller_id:67d344896a00b7b0951b4a6f):400000, (seller_id:67d36ab80fb81092296500b8):500000, (seller_id:67d36ae40fb81092296500ba):600000, (seller_id:670972463814f3334d650c74):100000]):asc,last_update:desc"
}
]
}Fanis Tharropoulos
06/17/2025, 11:21 AM29.0.rc5 onwards has those changes. Group by performance was improved as a result of it. Can you provide a set of reproducible steps so we can test it ourselves and see if things can be improved on the query level?Matheus Bombonato
06/17/2025, 12:12 PMMatheus Bombonato
06/17/2025, 1:13 PMFanis Tharropoulos
06/17/2025, 1:15 PMMatheus Bombonato
06/17/2025, 1:18 PMMatheus Bombonato
06/17/2025, 1:19 PMMatheus Bombonato
06/17/2025, 1:20 PMMatheus Bombonato
06/17/2025, 1:22 PMFanis Tharropoulos
06/17/2025, 1:24 PMv29.0 so we can see what we can do in terms of refactoring? The changes implemented for grouping in v29.0 improve RAM usage, but maybe the CPU impact on your queries was too much. You can send it through DMs if you prefer.Matheus Bombonato
06/17/2025, 1:26 PMMatheus Bombonato
06/17/2025, 2:24 PMFanis Tharropoulos
06/25/2025, 12:55 PMrc31. Can you try updating to that version and see if it fixes your performance issues?Matheus Bombonato
06/25/2025, 1:02 PMMatheus Bombonato
06/25/2025, 1:17 PMMatheus Bombonato
06/25/2025, 1:18 PMMatheus Bombonato
06/25/2025, 1:18 PM