September 23, 2009 at 9:08 am
My company is adding and admin section to our web site to allow users a gui to create and edit static pages the same as what is used for adding a topic to this forum. Since the pages can get rather large, what is best practice in sql to store this information?
September 23, 2009 at 1:06 pm
If you're planning on storing the entire file, I wouldn't recommend using SQL Server. Instead, I'd store it on the file system. If you're using 2008, you could use the FileStream object for the storage since that combines the best of both worlds, storing the file on a file system, but maintaining a link to ensure data integrity with the database.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 29, 2009 at 5:58 am
have a look at different CMS like silverstripe and jhoomla.......they may help you get better understanding of the storage...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply