Re: Article Storage: Files vs. Database

Unless you have really simple needs (is this a static site now and for the
foreseeable future ?) I would use a DB. It's likely you'll have anyway to
store other data thna just the description for each article (price,
availability, mark them as deleted, category, user ratings or whatever
else).

--
Patrice

"Jonathan Wood" <jwood@xxxxxxxxxxxxxxxx> a écrit dans le message de groupe
de discussion : #LIgSbnxIHA.4268@xxxxxxxxxxxxxxxxxxxxxxx
I'd like to build a Website that contains many articles. Two basic
approaches are to either store the articles in aspx files, possibly
indexed by the database, or to store the article text in the database.

Some advantages of storing them in files are simplicity, and efficiency.

Some advantages of storing them in the database are ease of some
operations, and the option of using SQL Server 2005 text index to
implement search.

Can anyone else offer some considerations for choosing between these two
approaches?

Thanks.

Jonathan


.

Relevant Pages

  • Re: Best Method Of Storing Up To Date Website Imgaes
    ... Storing images in a database will normally result in a bloated database that ... have a sample database on my website that you can view (or import any part ... to lots of images rather than store the image its self. ...
    (microsoft.public.access.forms)
  • Re: Article Storage: Files vs. Database
    ... anyway to store other data thna just the description for each article ... approaches are to either store the articles in aspx files, ... indexed by the database, or to store the article text in the database. ... Some advantages of storing them in files are simplicity, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Documents in Database
    ... > You can still use the filesystem to store documents and simply store the ... > documents metadata in the database. ... > managed as you would like, but you have the benefits of storing the docs ... > the filesystem...this is how most document management systems do it. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Space Required to store a file in database
    ... Unless you have/use your own compression routine, storing a file in a binary ... format ... I had a query on sql database, we know we usually store files of ... related to the amount of space required to store the files in the ...
    (microsoft.public.access.adp.sqlserver)
  • Article Storage: Files vs. Database
    ... Two basic approaches are to either store the articles in aspx files, possibly indexed by the database, or to store the article text in the database. ...
    (microsoft.public.dotnet.framework.aspnet)
Loading