Here is the description:

"remains and prices in the warehouse are imported for a long time (remains.xml), creates a load on the database as it stores prices and balances in the node (one record for each language version of the node, but one record would be enough for each item). Storage is required in a flat MySQL table. Import would also work faster if the XML file was processed via XMLReader instead of SimpleXML. "

What does the term "flat table" mean?

  • Usually, the term “flat table” hides a fully denormalized data set, i.e. "all data is in one table". But what exactly you and exactly in this matter you have in mind is unknown. - Akina
  • Something like this - "remains and prices in stock are imported for a long time (remains.xml), it creates a load on the database as it stores prices and residues in the node (one record for each language version of the node, but one record for each item would be enough ). Storage in a flat MySQL table is required. Import would also work faster if the XML file was processed via XMLReader instead of SimpleXML. " - Nikita
  • @Nikita - Is such an amendment to the question acceptable? - Kromster

1 answer 1

This means that this table is self-sufficient and contains all the information about the object. You do not need to make any additional joins in the request. Enough to do

SELECT * FROM mytable

and get all the information of interest.

This is often a denormalized table or view that encapsulates all the references to directories.