Good afternoon,

I have the following:
  • 44 643 of the file
  • 10,000 lines in each file (line length 8-16 characters)
  • The total weight is ~ 5 GB.

I need to make all the lines from the files in the database.
I think to do it locally via the console(php...), in a cycle, read each file line by line and insert a string into the database.

Question: how much such a database will weigh and is it correct? I chose a method for entering data into the database, will the script not be bent half way?
  • Well, what's stopping you, throw this data into the test database and check the size? – Thoughtless61 Jul 21 '19 at 16:25
  • 176 634 377 kBts – No One Jul 21 '19 at 16:51

2 Answers 2

the path is wrong
need multiadd/multi insert

the same 5gb + 1-3 on indexes/field conversion will weigh