xml versus database performance. 1

[DynastyEmpire6]

i have a couple regarding the performance of these two storage mediums.

Suppose I lets say 20 names in each of xml and database.
And I would query or write all 20 names to display on a webpage. My question is which one would be faster?
thanks.

 

[harebrain]

Neither XML nor databases are media. In fact, they use the same media: RAM or mass storage.

Retrieval speed would depend on the circumstances. With such a small dataset, in both cases the data would most likely all be in RAM, and the difference in speed would be negligible.

Remember that databases are for data storage and retrieval, and XML is for data portability. (At least, that was the original intent.)

 

[chiph]

And I would query or write all 20 names to display on a webpage. My question is which one would be faster?

And the answer, in all seriousness, is "it depends on how you use them."

If this is a critical issue for you, code up a small test app using both techniques and add timers to see which is faster in your environment, on your hardware, on your network.

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first