1

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?

2

Re: 10 million lines in the table

vlad2010;
10 million lines - not a problem. At the correct indexing and-or sectioning - will work on "hurrah"

3

Re: 10 million lines in the table

Only so.
Otherwise at appearance 101 questions  will be more.

4

Re: 10 million lines in the table

http://www.sql.ru/forum/1271836

5

Re: 10 million lines in the table

vlad2010;
Visualize the thoughts - outline the ER-diagram. Questions opened/closed, with edinstvennnym / a plural choice, the conditional passages etc.

vlad2010 wrote:

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.

the Approach with dynamic creation of columns depending on a dial-up of questions and answers of current inquiry is not for us. Structure of the questionnaire and as the facts of answers to it can be stored, for example, in plane EAV-like structure, or XML. If XML for integrity control it is possible to fasten check on XSD DB means.

6

Re: 10 million lines in the table

AmKad, whence such knowledge of sphere of inquiries? Or to unwinding you invent?

7

Re: 10 million lines in the table

Colleagues of thanks, my fears did not prove to be true and the circuit offered by me has the right to life

8

Re: 10 million lines in the table

vlad2010 wrote:

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?

It is better to increase a record count in tables
Than an amount of the table and fields.
When the last time considered at me in the thickest table was
Nearby 4  records.

9

Re: 10 million lines in the table

0k wrote:

it is better to increase a record count in tables
Than an amount of the table and fields.

But there are exceptions.