XML and MySQL Direct Query Performance
What, if any, is the performance overhead of using XML as an interface between a Php application (A) and a MySQL database via another Php application (B), rather than a direct query from a Php (A) application to the database
How much will this change between application (A) and the database on the same server and on separate servers?
a source to share
There are a number of variables that affect performance. Typically, connecting to a database is faster than transferring and parsing XML, but issues such as network latency, message size, and data complexity will affect faster.
On the other hand, there are several good reasons to have only one program interacting with the database, such as data integrity, which can lead to lower overhead.
a source to share
XML is a rather heavy language that has a lot of extra data to pass certain data (i.e. open / close tags). This processing is processor intensive, so for large messages it can have a significant performance impact. If the message sizes are small enough, the performance shouldn't be too bad, you just need to consider what the XML is generating and what is processing it.
In my opinion, MySQL will be faster, easier to develop and easier to manage (store / update / delete).
a source to share