Hello Everyone,

Our server hosting providers are saying that our web site is running slow because we are using ms sql server 2005 express edition which is a free edition and had only a capacity of handling up to 4 GB data.

And our database which we are currently using is now having more than 4.5 GB.

Hence they recommended us to go for a paid one that is specialized edition workgroup and gave us the following link http://www.microsoft.com/sqlserver/2008/en/us/editions.aspx to go through the comparison.

The hosting providers says that it will be around 4500 rupees per month for sql server. As we are a small firm and cant afford this much amount.

Please suggest any alternate methods.

Thanks,
Pollard

Sympathies with the problem of cost. There are plenty of ways of slimming down the size of your datanbase by refactoring it. However, if you really have run out of ways of keeping it below the 4 Gig limit, then the most obvious choice is PostgreSQL. However, the syntax has quite a lot of differences from SQL Server, and this is going to cost a lot of effort to migrate the application.

Can you split the database into logical parts that can be put on different SQL Express servers?

Use Ms sql server 2008 express edition, it has a 10GB db size limit.