Alternative Database Suggestions for Sql Server 2008

Question

I am launching a pretty successful adult site running on Asp.Net (C # 4.0) with the Sql Server 2008 R2 backend. We are launching the free version (Express) and are approaching our 10 GB data limit. We have about 100 thousand. Members and more than 7 million. Pageviews (750 thousand. Unique visitors).

I look for free (or cheap) alternatives, since we cannot afford the $ 7K + that Microsoft charges for its processor license for the standard version. There is not much hope that we will receive a free license either on our spark biz program!

We have a pretty typical scheme for any membership database. We are moving towards a more social aspect, so let's think about adult Facebook. There are currently 42 tables in our database. I am aware of the problems of scale. We grew at a rapid pace, so we are considering an alternative to NoSql.

So, I am considering Postgres and RavenDB. Postgres will have the least friction in terms of code changes and data migration. However, if we became Facebook (lolz), then I would write the data layer again (which upsets me).

So maybe start now with a NoSql solution such as RavenDb or Mongo, which has a built-in interface.

Thoughts?

Answer 1

Go to Postgres right now and solve the growth problem when you actually outgrow Postgres.

You must choose your own battles in this business, and premature optimization is one of the best ways to spend resources in software development.

Answer 2

I look for free (or cheap) alternatives, since we cannot afford the $ 7K + that Microsoft charges for its processor license for the standard version. We do not really hope to receive a free license or our biz spark program!

I like it when people run a business but don’t do their homework.

Check out Microsoft SPLA. You are a service provider, so you can sue this.

The processor license for web publications is about $ 20 per month.

http://www.microsoft.com/sqlserver/2008/en/us/web.aspx is a publication.

It makes no sense to rewrite everything to save this low cost.