Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / ASP.NET / General / February 2006

Tip: Looking for answers? Try searching our database.

Design Considerations

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jonathan Wood - 16 Feb 2006 18:19 GMT
I have an idea for several Web sites that would involve articles that can be
read. Article lengths will vary from short to a little longer, but nothing
really long.

I'm wondering at what point does it make sense to include the articles as
data in a database, and at what point does it make sense to include a
reference to the article in the database but to have the actual article as
an existing page.

Looking at sites like codeproject.com, it appears that the articles are not
stored within the database other than a reference to the existing page. But
I'm looking for ideas on this.

Thanks!

Signature

Jonathan Wood
SoftCircuits
http://www.softcircuits.com
Available for consulting: http://www.softcircuits.com/jwood/resume.htm

sloan - 16 Feb 2006 19:20 GMT
I worked on an applicaition that did both.

The "master" was stored in the db.
But.... the user could "publish" the file, which hard wrote it out to a
file.

This gave the user the ability to edit it, but not publish it until ready.

The system was based on users being able to modify the documents,
so.............it was worth the extra work.

..

Anyone who wanted the page, would always bring up the static/"published"
page.... mainly for performance reasons.

..

as a side note, persisting the page to the database helped with a trusted
storage mechanism.... aka, not relying on files to persist the data.

..

> I have an idea for several Web sites that would involve articles that can be
> read. Article lengths will vary from short to a little longer, but nothing
[quoted text clipped - 10 lines]
>
> Thanks!
Li-fan Chen - 16 Feb 2006 20:18 GMT
Hi Jonathan,

Basically what sloan said. Article submissions are stored in the master db
asap. Create a Windows service daemon to watch the DB for new articles, and
act on them every 100ms-5 minutes, if one is created, the daemon will render
it out to the file system. Logic needs to exist to rerender pages that links
to this new article.

Your IIS server will serve static pages a few times faster than ASPX pages:
with this publishing scheme, you'll serve five times or more customers per
second on the same box. But it's worth noting one shouldn't over-optimize,
make sure your server is bogged down first. Do please let us know how things
works out.

Best personal regards,
-- Li-fan

P.S. Depending on your needs, it may serve to spend your time caching db
requests, instead of caching entire pages.

Li-fan Chen
Software analyst/developer, Entrepreneur
Markham, Ontario, Canada
Jonathan Wood - 16 Feb 2006 22:51 GMT
Hmmm... Like I told sloan, I don't necessarily need the ability for users to
modify the articles, although submitting may be a future consideration.

Unfortunately, I have no idea what a Windows service daemon is. I'll print
your response and review it later.

Thanks.

Signature

Jonathan Wood
SoftCircuits
http://www.softcircuits.com
Available for consulting: http://www.softcircuits.com/jwood/resume.htm

> Hi Jonathan,
>
[quoted text clipped - 19 lines]
> Software analyst/developer, Entrepreneur
> Markham, Ontario, Canada
Jonathan Wood - 16 Feb 2006 22:49 GMT
Thanks. I will be the only one who can modify the articles. Although, I may
consider allowing users to submit articles in the future.

So I'm not sure how well the lessons of your application would apply to
mine. If users did not need to have the ability to modify articles, would
you do things differently?

Thanks again.

Signature

Jonathan Wood
SoftCircuits
http://www.softcircuits.com

> I worked on an applicaition that did both.
>
[quoted text clipped - 38 lines]
>>
>> Thanks!
Ben Fidge - 16 Feb 2006 20:28 GMT
I'd also point out that data stored in a database has some advantages over
static pages, although not performance-wise:

- Raw data is easier to manipulate and work with than data rendered on a
page. For example you may want to expose the data via a web-service or RSS
feed.
- Sql Server has full-text indexing built in which will allow you to provide
some pretty powerfull search functionality for your users.
- Maintaining relationships between documents and categorising is generally
easier than using the file-system. Ie, a particular article record can
easily be associated with multiple categories using tables, but a static
page can only exist under one folder.

I've been working on internet and intranet based Content Managment Systems
developed in-house for over 2 years now, and agree with the other posts in
this thread. Keep raw "master" data in the database, but render this to
static pages for performance benefits.

Ben

>I have an idea for several Web sites that would involve articles that can
>be read. Article lengths will vary from short to a little longer, but
[quoted text clipped - 10 lines]
>
> Thanks!
Jonathan Wood - 16 Feb 2006 22:53 GMT
Thanks, I don't understand some of the details of your suggestions but will
also save your response.

Signature

Jonathan Wood
SoftCircuits
http://www.softcircuits.com
Available for consulting: http://www.softcircuits.com/jwood/resume.htm

> I'd also point out that data stored in a database has some advantages over
> static pages, although not performance-wise:
[quoted text clipped - 30 lines]
>>
>> Thanks!
Darren Kopp - 17 Feb 2006 03:49 GMT
At the minimum, I would have ASP.NET cache the output of the page,
rather than hitting the database on every page hit.  You can determine
how long it caches it based on your needs, but i would tend to agree
with the other suggestions already posted.

Best of luck,
Darren Kopp
http://blog.secudocs.com/

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.