I have a huge flat file that contains a number of name value pairs. And I have to decide on a relational structure for the flat file.
What are the trade offs of having one table with having four fields : sequence no, foreign key from parent table, name and tag fields. And I can insert all the records into one table. Literally hundreds of thousands of records.
Conversely, I can normalize into a number of smaller tables and insert the same data there. Smaller tables with lesser numbers of rows.
Note that on query for a particular key value in the parent table, all related records are to be displayed to the user.
What are the performance issues here? Are there any other issues that I need to look at?