Re: Article Storage: Files vs. Database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

In reality it never works well.
I have a web site http://www.mspiercing.com if you look at it you going to
see search box there.

First problem I had is misspells. People on internet do not know how to
spell things. And SQL's full text does not work with misspells.

Another problem was plural vs singular form.

Another problem was weights. If person is looking for "belly ring" I want
the search to find and rank items with word "belly" first simply cause
"ring" exists in pretty much any item.


George.

"Jonathan Wood" <jwood@xxxxxxxxxxxxxxxx> wrote in message
news:OIZcL0yxIHA.5520@xxxxxxxxxxxxxxxxxxxxxxx
Can you elaborate on this? The full-text indexing was created for exactly
this purpose. Why does it not do a good job, or is a pain to use?

Thanks.

Jonathan

"George Ter-Saakov" <gt-nsp@xxxxxxxxxxx> wrote in message
news:uFjIVKwxIHA.4268@xxxxxxxxxxxxxxxxxxxxxxx
Implementing search functionality is pain.You might do it yourself or get
some third party solution like dtSearch or open source (just google
"serarch engine open source")

But from my experience the SQL server's full-text do not do a good job.

George.


"Jonathan Wood" <jwood@xxxxxxxxxxxxxxxx> wrote in message
news:eLKyj%23oxIHA.1504@xxxxxxxxxxxxxxxxxxxxxxx
Yeah, these are definitely some of the advantages. Have you made use of
SQL Server 2005's full-text indexing yet? With file-based articles,
implementing search is a pain.

Also, would love to see some samples of the sites you are referring to
if any of them are public.

Jonathan

"Peter Bromberg [C# MVP]" <pbromberg@xxxxxxxxxxxxxxxxxxx> wrote in
message news:83AAD161-D14E-4604-A6F5-FA46DA9C8774@xxxxxxxxxxxxxxxx
We use databases almost exclusively for this kind of "stuff". Its
easier to search, index, etc. and the content can be populated into a
"templatized" article page. It can also be cached via Partial page
caching.
Peter

"Jonathan Wood" <jwood@xxxxxxxxxxxxxxxx> wrote in message
news:%23LIgSbnxIHA.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: Fields?
    ... people to send data into my database. ... to yet in Dain's set of articles is exactly HOW you get the data to move ... from the Word document into the Access table so I am working in the dark on ... >> So, Suzanne, if you or anyone else is still with me after this long, ...
    (microsoft.public.word.formatting.longdocs)
  • Re: Looking for suggestion on how to organize a chest of photos, slides , negatives spanning 30 year
    ... as most articles I've read some articles that suggest 3 ring binders and ... special acid free materials. ... Three-ring binders can be a problem. ... I rolled my own database with a database program. ...
    (rec.photo.equipment.35mm)
  • Re: Updating the SQL key value
    ... author's login name from our articles and users tables: ... have a vary poorly normalized database. ... I think you're making a bad assumption there, Toby. ...
    (comp.lang.php)
  • Re: related pages ...
    ... Are you keeping the articles in a database or text ... you can search the database. ... if you parse the text of the pages, exclude common words (like adjectives, ... can then give rank to each one based on occurance. ...
    (alt.php)
  • Re: Want to write your SQL statements and even stored procedures in pure C#?
    ... I'll be writing more articles soon. ... > your reasoning is that you claim your solution is truly database ... SQL server, DB2, and Firebird. ... Second of all - sequences are not horrible, identity fields are the item that is poor. ...
    (microsoft.public.dotnet.framework.adonet)