Is XML the best data exchange format when importing large amounts of data as a script routine in PHP?

Question

If I have 50,000-100,000 skus products with supporting information, including specifications and descriptions that need to be updated on a regular basis (at least once a day), is XML the best way to switch to a data exchange format? The application is written in PHP, and I think that SimpleXML for PHP calls MySQL calls (as opposed to using application hooks to output data to the appropriate place in the database). The server will be based on Linux and I will have full root access. I know this is a pretty general question, so I made it a public wiki - I'm looking for a general approach that is considered best practice. If it matters to the Magento app.

Answer 1

You need to determine the “best” options for this scenario.

XML is verbose, which means two things

• You can provide detailed information about the data, including metadata.
• The file size will be large.

Another benefit you get with XML is the more advanced parsing / out-of-box selection with tools like XPath.

But there are many other formats that you could choose, each with its own advantage and disadvantage.

• Database dump
• Data exchange format
• Csv
• Json
• Serialized PHP

And a few more.

, , ( ?), , .

Answer 2

XML , . XML, , . , ( ) ( ). 100 . ( ), , XML.

Answer 3

JSON , XML, XML . XML .

, XML . JSON.

XML . , gzip XML.

Answer 4

XML . 10 000 , . .

SOAP XML (, , , SOAP XML ), PHP, , DAL , - SimpleXML.