XML vs MySQL

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
facets
Forum Contributor
Posts: 273
Joined: Wed Apr 13, 2005 1:53 am
Location: Detroit

XML vs MySQL

Post by facets »

Hi,
I am embarking on a mission to create statistics for a sales database. I am currently using PHP to extract data from the DB, manipulate the array, then create a XML file for graphing purposes. This method seems rather slow.

My question is, would outputting all 'related' data to XML then manipulate then graph be more efficient?

Has anyone done this kind of thing before? Any experiences you may want to share?

Many thanks,

Will.
timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Re: XML vs MySQL

Post by timvw »

facets wrote:Hi,
am embarking on a mission to create statistics for a sales database. I am currently using PHP to extract data from the DB, manipulate the array, then create a XML file for graphing purposes. This method seems rather slow.
I wonder why you've added the additional PHP layer... These days most sql dbmses will allow you to do (complex) processing in T-SQL/PL-SQL and export as XML...
Post Reply