|
Home > Archive > MS SQL Server > November 2006 > SQL Express vs Standard for asp.net online booking system??
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL Express vs Standard for asp.net online booking system??
|
|
|
| We are developing a new online booking system with asp.net 2.0 (vs2005) and
looking for options for the data store. Currently the PHP application
utilizes MySQL but we would like to use SQL Server in the rewrite.
What limitations would we run into with Express over Standard for such a
system? Is the 4GB size limit and advanced SQL features such as
replication, etc the only differences? We are looking for something to run
on a dedicated or VPS based Windows server that will only be running our app
and database. System is an online hotel type booking system with approx
7000-12000 transactions per month which may double in the coming year.
Express certainly has a cost advantage but we don't want to run into issues
with this version if there are any we should watch out for.
Also if we outgrow Express is it simply a matter of loading the same
database into SQL Standard with no further code or database changes?
| |
| Arnie Rowland 2006-11-28, 7:14 pm |
| It is simple to start out with Express (if you don't need the missing
functionality).
When you need the ability to use 2 or more processors, more memory, larger
databases, install Standard Edition and it is 'almost' as simple as detach
and attach the database files.
Carefully check out the version differences to make your decision.
SQL Server 2005 Features, Version Comparison
http://www.microsoft.com/sql/prodin...e-features.mspx
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"ML" <schooner@accesswave.ca> wrote in message
news:e7V%236H0EHHA.2176@TK2MSFTNGP02.phx.gbl...
> We are developing a new online booking system with asp.net 2.0 (vs2005)
> and looking for options for the data store. Currently the PHP application
> utilizes MySQL but we would like to use SQL Server in the rewrite.
>
> What limitations would we run into with Express over Standard for such a
> system? Is the 4GB size limit and advanced SQL features such as
> replication, etc the only differences? We are looking for something to
> run on a dedicated or VPS based Windows server that will only be running
> our app and database. System is an online hotel type booking system with
> approx 7000-12000 transactions per month which may double in the coming
> year.
>
> Express certainly has a cost advantage but we don't want to run into
> issues with this version if there are any we should watch out for.
>
> Also if we outgrow Express is it simply a matter of loading the same
> database into SQL Standard with no further code or database changes?
>
>
| |
|
| Thanks, so performance wise if we were running say a 2GB database on a
single CPU with 1GB of total ram there would be no differences between
Express and Standard correct (other than the server features itself), i.e.
it will be able to handle the same user load and transactions?
We are really trying to determine the best way to go for this web app -
shared SQL Server database with a 3rd party host, or a VPS/Dedicated hosted
server running our own copy of SQL Express.
"Arnie Rowland" <arnie@1568.com> wrote in message
news:eVc4mN0EHHA.4256@TK2MSFTNGP04.phx.gbl...
> It is simple to start out with Express (if you don't need the missing
> functionality).
>
> When you need the ability to use 2 or more processors, more memory, larger
> databases, install Standard Edition and it is 'almost' as simple as detach
> and attach the database files.
>
> Carefully check out the version differences to make your decision.
>
> SQL Server 2005 Features, Version Comparison
> http://www.microsoft.com/sql/prodin...e-features.mspx
>
>
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
>
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> You can't help someone get up a hill without getting a little closer to
> the top yourself.
> - H. Norman Schwarzkopf
>
>
> "ML" <schooner@accesswave.ca> wrote in message
> news:e7V%236H0EHHA.2176@TK2MSFTNGP02.phx.gbl...
>
>
|
|
|
|
|