SQL DB and WebSite

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 455,964 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,630 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MS SQL advertiser: Programming Forums

Thread Tools Display Modes

Views: 625 | Replies: 1

•

Join Date: Nov 2007

Location: CT

Posts: 6

Reputation: Stryker317 is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

Stryker317 Stryker317 is offline

Offline

Newbie Poster

SQL DB and WebSite

Nov 19th, 2007

I've always heard it best to keep processes separate when dealing with Application servers etc. My question is this:

Are there any best practices associated with creating a website that queries a SQL Database?

My thought is to separate the web element from the SQL Server and host it on it's own due to having 4 intranet sites total and the load it is imposing on our SQL Server.

Thanks in advance for any information.

•

Join Date: Dec 2007

Posts: 287

Reputation: ericstenson is an unknown quantity at this point

Rep Power: 1

Solved Threads: 28

ericstenson ericstenson is offline

Offline

Posting Whiz in Training

Re: SQL DB and WebSite

Dec 25th, 2007

Up to you, but you would be AMAZED at the abilities of Microsoft SQL... 4 sites probably isn't that taxing. Some shared hosting providers have (literally) hundreds of SQL databases serving hundreds of sites...