A
A
alehandroWEB2020-05-08 15:45:19
Database design
alehandroWEB, 2020-05-08 15:45:19

How to store client databases?

A service is being designed into which the user uploads his bases of telephone numbers in csv format. Then the csv file is parsed and saved to the database with subsequent processing. How to store this data?
Offhand, I came up with the following options:
1. Record all numbers of all users in one MySQL table with the user_id field. It is confusing that there will be hundreds of users, each with a csv file with thousands of numbers, and this plate will be millions of records long.
2. Create a separate MySQL table for each csv file. I feel that this is also a bad option to create hundreds of tables.
3. Store it all in mongo and don't worry about the base architecture at all.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
V
Vladimir Korotenko, 2020-05-08
@firedragon

Base with normal architecture to spit on one million of your records.
Here is an example request.
9aa00fdc50.jpg

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question