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
2009-06-27 22:28:19
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
2009-06-27 22:58:41