Topic: 10 million lines in the table
Good afternoon colleagues,
I project system of carrying out of inquiries.
The circuit at me appears such, what in one of tables can be 3-4 million lines approximately and this number I think can grow and to 10 million Question here in what, whether there will be such size a problem for Oracle 12? It is similar to an error of design or this such amount of lines normally?
As it turned out:
Let's present the table with inquiries - survey_table them will be approximately 17, the table with assignments survey_assignments to whom inquiry (nearby 17 * 2000 users), and survey_questions the table with questions approximately 17*100 is assigned. All answers will be in one table survey_results and I will select the necessary answer on id inquiry, and assignement id. 17 inquiries * 100 questions * 2000 users Also turn out.
I looked basis structure open source systems of inquiries Lime Survey and there I see that for everyone Survey there is a table of a type lime_survey_XXXXX, and lime_syrvey_token_XXXX where XXXX that that of type of number of inquiry. I thought from it to depart and use the fixed amount of tables. Besides, it is not pleasant to me that in their structure of the table with answers each line corresponds to the answer of one user to all questions. To an amount of columns in the table it turns out more than 100. On Mysql INNODB tables we even faced restriction on the maximum length of a line.
What think colleagues?