Q:

Design db for questions and answers with tags on a blog page

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

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.

