How to properly store data in a database?

Question

PHP

There is IM. I manually create a shopping cart and purchase history.
What is the best way to store records?
Make your own table for the basket and for the history, add all the data there, then display by user_id? Won't all this work slowly over time?

Answer 1

Unless there will be 100500 billion data that are written / read through the "bone" request!

Answer 2

Search by user_id, if it is of course in the index format, it will be quite fast, the only cant, do not display all the information at once