logo
g Text Version
Beauty & Self
Books & Music
Career
Computers
Education
Family
Food & Wine
Health & Fitness
Hobbies & Crafts
Home & Garden
Money
News & Politics
Relationships
Religion & Spirituality
Sports
Travel & Culture
TV & Movies

dailyclick
Bored? Games!
Nutrition
Postcards
Take a Quiz
Rate My Photo

new
Romance Movies
Creativity
Family Travel
Southwest USA
Irish Culture
Home Finance
Comedy Movies


dailyclick
All times in EST

Low Carb: 8:00 PM

Full Schedule
g
g ASP Site

BellaOnline's ASP Editor

g

Using ASP with a Dedicated Database

Guest Author - Lisa Shea

When you truly begin to base your website on database content, it's time to get yourself a dedicated MS-SQL or MySQL database system. This helps guarantee you proper response time and performance.

The dedicated database system can be on your web server, or can be on an entirely different server. The important part here is that the database is dedicated to you and you alone - nobody else will be using the database engine. This can make an amazing difference in performance. If you are sharing your database with a giant website that does millions of database operations a day, your own site's performance is going to suffer. If you instead have your very own copy of MS-SQL running, that solely hands out your data, you can tune that database engine to run as quickly as possible.

There are many different hosting options in the internet world. You can get a database that you manage yourself - everything from setting up backup times to optimizing the way new tables are created. This is the method I prefer myself, but it does of course require you to put some time into learning how to properly manage a database. On the other hand, you can hire someone (or pay your hosting company) to do these things for you. This of course costs more, and you are trusting that they know what they are doing. Many hosting companies tell you they are experts but actually just want your money. It is often hard to tell the difference until something goes disastrously wrong with your live site.

Learning to manage a SQL database does not take years of effort - but it should take a few weeks of study. This is a very important skillset to have if you are working with databases - and can bring in lucrative contract work or job offers if you learn to do it well. Even if you simply learn it for your own website's use, you can end up vastly improving your site's performance by properly tuning your SQL database.

I highly recommend taking this route as soon as your finances allow you to. You should be able to get yourself a sturdy, fast MS-SQL machine for about $100/month. If you want to put your website on that machine as well, that is not a bad price for a standalone web / db app machine.
This site needs an editor - click to learn more!

Add Using+ASP+with+a+Dedicated+Database to Twitter Add Using+ASP+with+a+Dedicated+Database to Facebook Add Using+ASP+with+a+Dedicated+Database to MySpace Add Using+ASP+with+a+Dedicated+Database to Del.icio.us Digg Using+ASP+with+a+Dedicated+Database Add Using+ASP+with+a+Dedicated+Database to Yahoo My Web Add Using+ASP+with+a+Dedicated+Database to Google Bookmarks Add Using+ASP+with+a+Dedicated+Database to Stumbleupon Add Using+ASP+with+a+Dedicated+Database to Reddit




RSS | Related Articles | Editor's Picks Articles | Top Ten Articles | Previous Features | Site Map


For FREE email updates, subscribe to the ASP Newsletter


Past Issues


print
Printer Friendly
bookmark
Bookmark
tell friend
Tell a Friend
forum
Forum
email
Email Editor


Content copyright © 2014 by Lisa Shea. All rights reserved.
This content was written by Lisa Shea. If you wish to use this content in any manner, you need written permission. Contact BellaOnline Administration for details.

g


g features
Best uses for RSS

RSS and its future.

Force Download Dialog box with ASP

Archives | Site Map

forum
Forum
email
Contact

Past Issues
memberscenter


vote
Poetry
Daily
Weekly
Monthly
Less than Monthly



BellaOnline on Facebook
g


| About BellaOnline | Privacy Policy | Advertising | Become an Editor |
Website copyright © 2014 Minerva WebWorks LLC. All rights reserved.


BellaOnline Editor