Wednesday, March 7, 2012

Can I use SQL Express for a large website?

I run a tutorial website with average 50,000 page views per day and hoping to
grow this number to 100,000 per day in next 1 year. Currently, I use MS
Access database and lot of caching in the web site for performance reasons.
Can I use SQL 2005 Express for such a good traffic web site? Does SQL 2005
express support that much hits? I can continue to use lot of caching to avoid
too many hits to database.
Sounds like a good fit., but it is difficult to talk about specific numbers
or metrics. Sql Express should outperform anything you are able to do with
Access. Sql Express will only utilize a single processor and 1gb of ram.
Databases are limited to 4gb in size.
-A
"ToJo" <ToJo@.discussions.microsoft.com> wrote in message
news:C32CCA39-1E40-4862-AE8C-57833F50459F@.microsoft.com...
> I run a tutorial website with average 50,000 page views per day and hoping
to
> grow this number to 100,000 per day in next 1 year. Currently, I use MS
> Access database and lot of caching in the web site for performance
reasons.
> Can I use SQL 2005 Express for such a good traffic web site? Does SQL 2005
> express support that much hits? I can continue to use lot of caching to
avoid
> too many hits to database.

No comments:

Post a Comment