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 13 1399
We use databases almost exclusively for this kind of "stuff". Its easier to
search, index, etc. and the content can be populated into a "templatize d"
article page. It can also be cached via Partial page caching.
Peter
"Jonathan Wood" <jw***@softcirc uits.comwrote in message
news:%2******** ********@TK2MSF TNGP02.phx.gbl. ..
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
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]" <pb*******@nosp ammin.yahoo.com wrote in message
news:83******** *************** ***********@mic rosoft.com...
We use databases almost exclusively for this kind of "stuff". Its easier
to search, index, etc. and the content can be populated into a
"templatize d" article page. It can also be cached via Partial page
caching.
Peter
"Jonathan Wood" <jw***@softcirc uits.comwrote in message
news:%2******** ********@TK2MSF TNGP02.phx.gbl. ..
>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
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" <jw***@softcirc uits.comwrote in message
news:eL******** ********@TK2MSF TNGP05.phx.gbl. ..
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]" <pb*******@nosp ammin.yahoo.com wrote in message
news:83******** *************** ***********@mic rosoft.com...
>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" <jw***@softcirc uits.comwrote in message news:%2******* *********@TK2MS FTNGP02.phx.gbl ...
>>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
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" <jw***@softcirc uits.coma écrit dans le message de groupe
de discussion : #L************* *@TK2MSFTNGP02. phx.gbl...
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
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****@cardone .comwrote in message
news:uF******** ******@TK2MSFTN GP02.phx.gbl...
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" <jw***@softcirc uits.comwrote in message
news:eL******** ********@TK2MSF TNGP05.phx.gbl. ..
>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]" <pb*******@nosp ammin.yahoo.com wrote in message news:83******** *************** ***********@mic rosoft.com...
>>We use databases almost exclusively for this kind of "stuff". Its easier to search, index, etc. and the content can be populated into a "templatize d" article page. It can also be cached via Partial page caching. Peter
"Jonathan Wood" <jw***@softcirc uits.comwrote in message news:%2****** **********@TK2M SFTNGP02.phx.gb l... 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
Yes, I agree that a database will be needed for one purpose or another.
But then how good are my options for implementing search functionality?
Thanks.
Jonathan
"Patrice" <http://www.chez.com/scribe/wrote in message
news:10******** *************** ***********@mic rosoft.com...
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" <jw***@softcirc uits.coma écrit dans le message de groupe
de discussion : #L************* *@TK2MSFTNGP02. phx.gbl...
>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
Any decent article site MUST have good full-text searching.
--
Jonathan Wood
SoftCircuits Programming http://www.softcircuits.com
"Patrice" <http://www.chez.com/scribe/wrote in message
news:E7******** *************** ***********@mic rosoft.com...
Which kind of search ? LIKE would be my first option for text search.
Depends then on how much rows, how much text columns in which to search
for keywords, their size, if you can filter rows using better criteria
before applying LIKE, if users tends to always use the same keywords
etc...
Only then you can consider full text search (even SQL Express (with
advanced services) has now full text search)...
--
Patrice
"Jonathan Wood" <jw***@softcirc uits.coma écrit dans le message de groupe
de discussion : uf************* *@TK2MSFTNGP06. phx.gbl...
>Yes, I agree that a database will be needed for one purpose or another.
But then how good are my options for implementing search functionality?
Thanks.
Jonathan
"Patrice" <http://www.chez.com/scribe/wrote in message news:10******* *************** ************@mi crosoft.com...
>>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" <jw***@softcirc uits.coma écrit dans le message de groupe de discussion : #L************* *@TK2MSFTNGP02. phx.gbl... 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
Of those you listed, plural vs singular would be my biggest worry.
Yeah, I understand people don't know how to spell. But if their search
doesn't turn up anything, then I'm not going to feel too guilty when they
misspelled something. Although I understand it's a bit different if your
site is selling stuff, in which case, the site loses when they don't find
what they're looking for.
Thanks.
--
Jonathan Wood
SoftCircuits Programming http://www.softcircuits.com
"George Ter-Saakov" <gt****@cardone .comwrote in message
news:eJ******** ******@TK2MSFTN GP05.phx.gbl...
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" <jw***@softcirc uits.comwrote in message
news:OI******** ******@TK2MSFTN GP06.phx.gbl...
>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****@cardone .comwrote in message news:uF******* *******@TK2MSFT NGP02.phx.gbl.. .
>>Implementin g 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" <jw***@softcirc uits.comwrote in message news:eL****** **********@TK2M SFTNGP05.phx.gb l... 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, implementi ng 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]" <pb*******@nosp ammin.yahoo.com wrote in message news:83******** *************** ***********@mic rosoft.com... We use databases almost exclusively for this kind of "stuff". Its easier to search, index, etc. and the content can be populated into a "templatize d" article page. It can also be cached via Partial page caching. Peter > "Jonathan Wood" <jw***@softcirc uits.comwrote in message news:%2**** ************@TK 2MSFTNGP02.phx. gbl... >I'd like to build a Website that contains many articles. Two basic >approach es 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 >implemen t search. >> >Can anyone else offer some considerations for choosing between these >two approaches? >> >Thanks. >> >Jonathan >> >
George,
You said "I hear all the time how loading a straight file is more
efficient"
And my point was that this is an illusion. That is why many people still
believe it. And you hear it all the time.
File System is designed as a sequential list. If you need to find file
a.txt in it there is no other way but to scan the whole list.
I understand that. My understanding was that transferring the content was
faster from a file that transferring it over a database connection, and not
so much look-up time. My understanding was also that this has been well
testing and documented. But I will certainly admit I haven't ran any tests
myself.
Also MS was planning for long time ago move file system to MS SQL engine.
Not sure if it's still in works or not.
Not sure how great that sounds. Some sort of index to allow a binary lookup
makes sense though.
--
Jonathan Wood
SoftCircuits Programming http://www.softcircuits.com This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Dave Moore |
last post by:
Hi All,
I want to be able to store data as part of my website. I'm assuming that
I''ll need to use PHP scripts to provide this functionality, but what would
the best aproach be to storing data?. I could use a database of some sort
(maybe MySQL?), but I'm wondering whether there are any other aproaches to
data storage that would be less elaborate than a full database.
Any ideas?.
Dave
|
by: R Reyes |
last post by:
what are the pros/cons of uploading a file into a database (like access, sql
server, oracle) vs. uploading a file into a folder (and only storing its path
in a database table) ?
i've never had to upload a file into a database and am assuming it's easier
to just put files in a folder with its path stored in the database. storing
a file in the database seems like a bit more work and is just "another
solution" rather than a recommended...
|
by: Troels Arvin |
last post by:
Hello,
For some very data-intensive projects it's interesting how much space the
DBMS uses for the storage of data, so I'm investigating how space
efficient different DBMSes are.
In the PostgreSQL manual, it's written that values of the type INTEGER
take op four bytes. I was curious about how close to real-World this
number is, so I did a test: How much space does PostgreSQL use when
storing 100000 rows where each row consists of a...
|
by: Jeremy |
last post by:
Hi all,
I'm getting very confused about how DB2 uses shared memory and I
wonder if someone could clarify matters for me, please ?
We are running 32bit DB2 V7.2 FP9 under AIX 4.3.3 on a machine with 64
Gb of memory with a single non-partitioned database using extended
storage and with intra-parallelism enabled.
I've been experimenting with changing various parameters in an attempt
|
by: Namratha Shah \(Nasha\) |
last post by:
Hey Group,
After a long week end I am back again. Its nice and refreshing after a short
vacation so lets get started with .NET once again.
Today we will discuss about Isolated Storage. This is one of the topics
which I find interesting as I feel that it has a lot of practical usage or
applicability.
We all know that all applications need some storage space to archive certain
| |
by: SSUK |
last post by:
Hi,
Is it better to store files in Database or to store on Hard Disk /network ?
On a Web application using .NET...
|
by: cristizaharioiu |
last post by:
Hello,
I am beginner with db2 ( DB2 v9.1.0.1 running on RHEL 4); this is my
first post.
I have this error " SQL0968C The file system is full. SQLSTATE=57011""
in my instance configured with AUTO STORAGE ON & AUTORESIZE (indeed,
the file system was almost full)
I tried to add new storage using "alter database XX add storage
|
by: Redhairs |
last post by:
In a web farm environment, how to store the user uploading files for future
access?
Store them in db, local file system or centralized file server?
If trying to storing the file in local file system or centralized file
server, how the web server
receives the uploading file and sync to each web server's local file system?
or the centralized
file server?
|
by: myjish18 |
last post by:
Hello,
We have a DB2 UDB database v8.2.7 (db2 v8.2 fixpak 14) on AIX 5.3
which has Automatic Storage (AS) enabled. We want to disable
automatic storage on entire database and/or disable automatic storage
on all tablespaces. DB2 Manual says it once AS is enabled, it cant be
changed. Is there any way to disable the AS or any other alternative?
Please advice.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |