Restaurant Order App, every Item ordered will create a data [ Ordered Item ]
- POS (point of sale) will Do a search for [Ordered Item] that ( match with Restaurant, Payment Status, Kitchen Status )
My Question :
What if i Eliminate Do A Search, but everytime moving [Ordered Item] to a Database that record list, example
→ Unpaid Ordered Item List
→ Served Ordered Item List
→ In Kitchen Ordered Item List
So after certain workflow, i just move the [Ordered Item] into relevant List,
I no longer need Do a Search for XXX, instead just call the List from Database.
– My concern. I have about 10 restaurant now, the [Ordered Item] accumalated already 10k just 2 months and started to see slow down in certain process flow…
Open to any better suggestion.
Thanks in Advance