Page 1 of 1

XML vs MySQL

Posted: Tue Jul 17, 2007 6:05 am
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.

Re: XML vs MySQL

Posted: Tue Jul 17, 2007 12:55 pm
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...