I had 1 million records inserted par day. and my front end is c#.net 4.0.

So what is the best option for database server to gain the best performance. this is my par day traffic.

Oracle 11g vs MS Sql Server 2008 R2

link|improve this question
feedback

closed as not constructive by SvenW, Chopper3 Sep 22 '11 at 10:32

This question is not a good fit to our Q&A format. We expect answers to generally involve facts, references, or specific expertise; this question will likely solicit opinion, debate, arguments, polling, or extended discussion. See the FAQ for guidance on how to improve it.

1 Answer

Your design, code and indexing matter far more than your choice of RDBMS. Or a poor choice of disk layout (eg one RAID 5 volume for everything)

In this case, SQL Server because your are using .net. That's all.

link|improve this answer
Thanks for your reply. – Ronak Sep 22 '11 at 10:56
feedback

Not the answer you're looking for? Browse other questions tagged or ask your own question.