I would like to develop a public e-commerce application, where users who download it from stores can enter and view products from affiliated stores. on the other hand I have an administrative application (pay per user) where each store can see their information, add their products and dispatch the orders that users make. My concerns are:
1- What happens in the public application when my data in daily transactions grows?
2- the public application will be slow ?.
3- if I do not store the daily transactions in the public application and use webhook to copy the information to another table (which only allows adding records) this table will slow down the public application being read-only? …
*** In short, how can I prevent my application from slowing down as it grows in users and transactions?
I found this information, but I still don’t know if activating that function (Filter out all existing rows?) and this table grows in records, will my public application slow down?