Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...SQL Express vs SQL Server StandardSQL Express vs SQL Server Standard
Previous
 
Next
New Post
3/4/2010 2:17 PM
 
Jan Olsmar wrote:

I have also some good experience with the express version. But in high volume sites the standard is the choice.

 

Thanks Jan, and just wondering what you would consider "high volume"?

The sites I am looking at deploying are all essentially eCommerce sites, whereby the amount of traffic will be dictated by several factors, inc time of year (summer busier than winter ... just coming out of our summer though), school holidays and other unpredictable timings. So the traffic will not be consistent, however at it's peak we are looking at approx 1500 purchases in a day, at the very heaviest 1500 per day, per site (looking at 5 sites on one SQL instance, so 7500 purchases in a single day at the very, VERY highest. I'd be surprised to see that many in a single day though)

 
New Post
3/4/2010 2:23 PM
 
Thanks to everyone for the responses so far, can't say I meant to cause any arguments about the virtues of SQL Express It might be one of those things where we see how much we can get a SQL Standard license for (the machine has 2 physical CPUs though, so that means x2 licenses) but of course we need to be able to sell this solution to our clients also, so if that gets too expensive we can always try SQL Express and see how it goes Using Express can't be any worse than the situation we're finding ourselves in now, and whilst I don't expect any issues with DB size (the back-end production data will still be housed on a full SQL Server, just the web site would go on Express) I'll need to make sure we don't run into issues with the web service communications we'll be running
 
New Post
3/4/2010 3:33 PM
 

Its rather hard to tell, I have no sites running with express with that volume. The limitations in express is one cpu and 1gb memory and 4 gb Database size.

I asume if you get p to 7500 purchases the trafic is much larger so my recomendations is take the investment in a web edition.

But it would be nice to know if it worked with the express edition :)

 
New Post
3/4/2010 4:35 PM
 
Jan Olsmar wrote:

Its rather hard to tell, I have no sites running with express with that volume. The limitations in express is one cpu and 1gb memory and 4 gb Database size.

I asume if you get p to 7500 purchases the trafic is much larger so my recomendations is take the investment in a web edition.

But it would be nice to know if it worked with the express edition :)

 

Thanks Jan, I didn't realise the limitations were still so tight with SQL Express 2008 (knew they were in place with 2005).

That may force my hand considering I'll have two CPUs and starting off with 4GB RAM

 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...SQL Express vs SQL Server StandardSQL Express vs SQL Server Standard


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out