BLOB - Document System

[alwinSCH]

Hi, I want to make a simple document system. But i don't know what to do store my files in SQL or store a little XML in the table 1. Store the whole file in the DB (like a BLOB or something like this) including other columns (title, little explanation, author, date,...) 2 Store a little XML file in the DB with a filepath to the file but in XML all the metatags like the columns in point 1. I don't know which is the best choise!!! Ok, i shall restrict the files to a max of 10Mb. for versioning - The XML solution is maybe better? Searching goes faster in ...? performance...? size of DB I think it will grow rapidly? Security easiest in which solution? Can anyone put me in the right direction!!! Please what do you think

[andyharman]

You might want to consider using Microsoft SharePoint. It does all of this and is free.