---
title: "Comment by QRiQRa Team on \"System Design Drill Day 16: Product Search, Ranking and Typeahead\" | Hashnode"
description: "Treating the index as a slightly stale copy, with MySQL deciding price and stock at checkout, answers the first question well. Search can be a little behind, bu"
url: "https://hashnode.com/posts/system-design-drill-day-16-product-search-ranking-and-typeahead/6af98c0ea00b30bc633fb5b6/comment/6afbd8155b421c2b428b90e2"
---

[Discussion](https://hashnode.com/posts/system-design-drill-day-16-product-search-ranking-and-typeahead/6af98c0ea00b30bc633fb5b6)

Comment [System Design Drill Day 16: Product Search, Ranking and Typeahead](https://hashnode.com/posts/system-design-drill-day-16-product-search-ranking-and-typeahead/6af98c0ea00b30bc633fb5b6)

[QRiQRa Team](https://hashnode.com/@qriqra)

[3d ago](https://hashnode.com/posts/system-design-drill-day-16-product-search-ranking-and-typeahead/6af98c0ea00b30bc633fb5b6/comment/6afbd8155b421c2b428b90e2)

Treating the index as a slightly stale copy, with MySQL deciding price and stock at checkout, answers the first question well. Search can be a little behind, but the order cannot. Keeping price and stock updates on their own path, apart from bulk imports, also seems like the right call. One small addition to the outage plan: if results come from cache or FULLTEXT, the "search is limited" notice could also say whether prices shown might be out of date. That way a user is not surprised when checkout shows a different number.

[Anish Ansari](https://hashnode.com/@anish78)

[3d ago](https://hashnode.com/posts/system-design-drill-day-16-product-search-ranking-and-typeahead/6af98c0ea00b30bc633fb5b6/comment/6afbd8155b421c2b428b90e2#reply-6afc576896c3ae41d2695948)

Good call on the stale prices. Adding a line like "prices may have changed, final price is confirmed at checkout" to the limited search notice would make that MySQL check feel expected instead of surprising.

[QRiQRa Team](https://hashnode.com/@qriqra)

[2d ago](https://hashnode.com/posts/system-design-drill-day-16-product-search-ranking-and-typeahead/6af98c0ea00b30bc633fb5b6/comment/6afbd8155b421c2b428b90e2#reply-6afd2a85e8aa564c17834b17)

Thank you. That line would make the checkout check feel expected, rather than a surprise at the last step. We appreciate you taking the suggestion further.
