Choosing a database
Posted: Thu 28 Jun 2012 05:04
Hello,
I coming from a shop that was SQL Server, using MS's provider for EF 4.x. At my new shop we are looking at going away from SQL server for various reasons, but have misgivings about the non-sql-server path when using EF.
We have a few projects that we are about to start, that will likely get to 1000 users, and millions of records. So performance is an issue, but we are building Facebook or twitter here.
The biggest question is how much friction will there be going with My or Postgres? It seems that DevArt is the only one making commercial grade providers (in my so far limited research), so assuming the DevArt providers, which is the path of least resistance? Which of the DevArt providers, are the most feature complete, updated the most frequently, break the least, etc.
Is the performance of EF with the DevArt providers similar on Postgres and My?
I would love to hear some insight from the DevArt guys on which DB they would choose, as well as from the soldiers on the ground about their experiences with the two using EF. Basically if you were starting a project from scratch, and had to choose one of the two to use with EF and DevArt providers, which would you go with, and why?
Thanks,
~S
I coming from a shop that was SQL Server, using MS's provider for EF 4.x. At my new shop we are looking at going away from SQL server for various reasons, but have misgivings about the non-sql-server path when using EF.
We have a few projects that we are about to start, that will likely get to 1000 users, and millions of records. So performance is an issue, but we are building Facebook or twitter here.
The biggest question is how much friction will there be going with My or Postgres? It seems that DevArt is the only one making commercial grade providers (in my so far limited research), so assuming the DevArt providers, which is the path of least resistance? Which of the DevArt providers, are the most feature complete, updated the most frequently, break the least, etc.
Is the performance of EF with the DevArt providers similar on Postgres and My?
I would love to hear some insight from the DevArt guys on which DB they would choose, as well as from the soldiers on the ground about their experiences with the two using EF. Basically if you were starting a project from scratch, and had to choose one of the two to use with EF and DevArt providers, which would you go with, and why?
Thanks,
~S