Log in

View Full Version : XML vs MySQL



XManBG
09-15-2011, 01:49 PM
Hi folks, I was thinking and wanted to ask:

can I recommend using XML for small database solutions, which don't have to be updated, and just manually expanded, only when needed... or do I miss something??

Cheers

traq
09-15-2011, 06:23 PM
do you need to search it?

XML is exponentially slower than a database. I only use XML when:

1) I never need to search for particular values,
2) I never need to do much processing (sorting/ editing/ etc.)
3) The data is always needed in the same (preferably raw) format

even so, I usually use JSON in those situations (e.g., config files, sending data to javascript, etc.).
If you're unsure, use the database.