CODEWITHSUNDEEP
databaseperformancedatabase-design
Anshul
Anshul

Reputation: 645

Which DB used for the application that deals with milions of the rows

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.

Upvotes: 0

Views: 79

Answers (1)

Alireza
Alireza

Reputation: 6868

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.

Upvotes: 1

Related Questions