Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Vaishak
Starting Member
1 Post |
 Posted - 2009-06-30 : 08:25:18
|
| Hi,I want to build a Web Application for the HR team. For start I want to keep the cost minimal.I was thinking of using the SQL Server 2008 Express. I have never used it for Web App, used it only for stand alone system. I was reading an article that said there is a limitation of 1 CPU socket. I am not sure what does this mean. I want to know if SQL Express edition is suitable for Web Application. How about using MS Access as database. I have to do a proposal. Any information will help. RegardsVAishak |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2009-06-30 : 13:30:16
|
| depends really.Who are u hosting with ? they should be able to rent you a db for your project. |
 |
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2009-07-03 : 17:28:18
|
| I cannot see any value in using access over SQL.The limitation for sql express varies by version. SQL Express 2008 is limited to 1 cpu socket meaning single dual trip and quad corp cpu's count as 1.(allowing you to use all 4 cores on quadcores)There is also a database size limitation, and a maximum memory limitation. YOu can find these on the microsoft website.1cpu is more than enough for the vast majority of websites. In my experience you can get dozens of pages per second from 1 cpu. With that kind of traffic it should be easy to justify beefy hardware and SQL cpu licenses. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-07-03 : 17:34:09
|
This forum is run with SQL Server Express.
Microsoft SQL Server MVPN 56°04'39.26"E 12°55'05.63" |
|
|
|
|
|
|
SQL 2008 Express edition