MySQL Forums
Forum List  »  Performance

How to design my data structure to optimize it.thank you
Posted by: xiangsheng jiang
Date: September 05, 2020 10:14PM

In a total product data table with 100,000 pieces of data, 10,000 merchants can select products from the data table and put them in their online stores. My initial idea is that when a certain merchant selects a product from the total product list, it will copy the selected product to the merchant product list. But I am worried that the merchant product table will be too large (For example, each merchant copies 1,000 products from the total product table, and 10,000 merchants are 10 million pieces of data)
I would like to ask next: How to design my data structure to optimize it?

Options: ReplyQuote


Subject
Views
Written By
Posted
How to design my data structure to optimize it.thank you
565
September 05, 2020 10:14PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.