views:

51

answers:

2

Use XML files based or SQL server? Which would be more efficient based on storage size, retrieval and performance?

+1  A: 

Assuming a big number of blog entries, the database is the way to go. Suppose you want to search a entry with certain text, with the database, you just query using LIKE, in the XML scenario you have to sequentially load the files into memory, do a string search, etc. Painful and slow.

tekBlues
A: 

its not exactly blog, A webpage where i'm adding a answer question section with tags (similar to stackoverflow but not same), and they will have tags

rs