| Author |
 Topic  |
|
|
multiplex77
Starting Member
Singapore
24 Posts |
 Posted - 09/10/2007 : 06:18:38
|
Hi,
I'd like to get the experts' advice on whether SQL server 2005 Express edition (SSE) is suitable for medium scale web applications.
I have looked through the reviews of SSE. From what I understand, its limitations over the MSSQL 2005 Standard are:
1. SSE limits database size to 4GB and memory to 1GB.
2. Support for only 1 CPU.
3. No analysis or reporting services.
4. No full text indexing
5. No SQL Agent.
I have a web application that is currently running on a shared web host with a shared MSSQL 2000 database. I'm thinking of shifting to a Virtual Private Server, where I can install SSE for free.
Currently my app has about 14,000 page views a month, and each of them pulls out data from the database. I don't use any analysis or reporting services, or full text indexing or SQL Agent (for now).
My questions:
1. Is 1GB memory sufficient for this type of application?
2. Is there any reason I should not be using SSE for my type of application?
Thanks in advance for the help. |
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
30421 Posts |
Posted - 09/10/2007 : 06:20:24
|
1. Yes
2. No
E 12°55'05.25"
N 56°04'39.16" |
 |
|
|
multiplex77
Starting Member
Singapore
24 Posts |
Posted - 09/10/2007 : 06:44:38
|
| Thanks!! |
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
30421 Posts |
Posted - 09/10/2007 : 06:51:52
|
14,000 visits per month, is about one visit every three minutes.
E 12°55'05.25"
N 56°04'39.16" |
|
|
|
multiplex77
Starting Member
Singapore
24 Posts |
Posted - 09/10/2007 : 07:28:38
|
| That's very low, I presume? At what point would SSE be insufficient then? |
|
|
|
Zoroaster
Aged Yak Warrior
USA
702 Posts |
Posted - 09/10/2007 : 09:30:03
|
The no SQL Agent is a bit of a pain, but there are definitely other ways to handle jobs. Overall it sounds like an excellent choice.
Future guru in the making. |
|
|
| |
Topic |
|
MSSQL 2005 Express for web application?