[RESOLVED] what perform better XML vs MySql

[itaym02]

Greetings.

I need to store some data for each user.
It ain't alot of data (around 1-5kb).

I will also might need to do some minor manipulations on the data, RegExp will do the job nicely with the XML.

What will be better to use in this case: A MySql table or a small XML file for each user?

The points I am worried are:physical storage place on the server, and performance.

Thanks

[planetsim]

XML is not a proper solution for this case. XML is suppose to be used as away of getting data from one program to another / one website to another, usually the data comes from a Database. Since your not going to be using this as a way for other programs/sites to be able to view user information (which I strong suggest not doing so) a Database is a better solution as its meant for storage, indexing etc whilst XML isnt.

[itaym02]

thanks,
How do I resolve the thread?

[planetsim]

In the Thread Tools Menu up top click on that in the drop down should be Mark Thread Resolved link

[itaym02]

Thanks,

One more thing. In performance point of view, what will be better in the example above, the XML or MySql?

[laserlight]

One more thing. In performance point of view, what will be better in the example above, the XML or MySql?

It depends. You will have to try both and compare.

[itaym02]

thanks

(Great title, b t w )