Performance between w2k filesystem and SQLServer.

walkdan
walkdan used Ask the Experts™
on
I'm writing a BBS program. I will choose a datastore system to store articles. I hesitate between w2k filesystem and SQLServer. can anyone give me a experience that what is better performance.

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
Since the article would be stored in a blob type field in the SQL database, I don't think that there would be a big speed difference, if anything, then the win2k filesystem would probably be faster, since it caches files used in memory.

And a little comment about using SQL, not related to the question directly.

SQL has several advantages like full text search in the article, it's easier to select and or order the data in a SQL server. A suggestion for an article record could be something like this;

ArticleMaster:
RecordIdentity (unique), Number, Name, Author, ..more data..
ArticleDetail:
RecordIdentity (unique), Number, ArticleText (blob text)..

Then a full article using Number as a lookup would look like;

Master:
  1,1,'An article','Author'
Detail:
  1,1,'text for page one'
  2,1,'text for page two'
  3,1,'text for page three'

That way it should be easier to build a fairly featurerich generic article system.

Commented:
maybe you can use both.
an article's picture stored in a file, and it's name, properties like pirce and a link to the file stored in the db.
so if you like to make an internet-presentation for you products sometimes,
you can use the pictures stored in the filesysteme and put up an easy to update website by using the sql-server from from the frontend.
walkdan:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial