0

I am creating an application that is going to handle millions of rows per month. I have a major concern about the database performance that can handle these large numbers of rows as well give fast result.

I have an option for the databases like MySQL, SQL Server, ORACLE, DB2...

Hopefully somebody could give me the good way to over come with these problem.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Anshul
  • 635
  • 2
  • 11
  • 27
  • 2
    All of the choices you listed should have no trouble with millions of records per month if properly configured. If you edit your question to offer more details about your situation or more specific questions, the answers you get will probably be more helplful. – TetonSig Dec 26 '11 at 05:59
  • you might find the following of interest http://stackoverflow.com/questions/4419499/mysql-nosql-help-me-to-choose-the-right-one-on-a/4421601#4421601 – Jon Black Jan 07 '12 at 15:07

1 Answers1

1

RDBMSes don't have any problem with what you mentioned, the problem is you (sorry for that).

  • how do you design your database schema?
  • how do you chache your queries?
  • how do you use RDBMS functions (in efficient or inefficient way)?
  • database design
  • normalization
  • replication
  • ...

The list goes on, just try to learn more about one of them (MySQL, SQL, Oracle) in more practical way.

Alireza
  • 6,497
  • 13
  • 59
  • 132
  • Thanks for the reply,i pretty much aware of this points,but if RDBMS is the only thing that care of your Db,Why number of the DB solutions are introduce in the market? – Anshul Dec 26 '11 at 06:48
  • I couldn't get your point, do mean why do we have different RDBMSes? – Alireza Dec 26 '11 at 11:18
  • There actually aren't a large number of RDBMs in the market with significant market share. The shakeout for relational database software happened in the 1990s. – Paul Keister Dec 27 '11 at 07:00