Best online performance database

Question

0.00/5 (No votes)

See more:

, +

I know this might be very common question but i need to know the database that has:-

1. The best performance (not talking about the application of the code but talking about when we simply retrieve data from database "Select A from Table1")
2. Can handle large load of data (probably would receive 1,00,000 queries per minute or more)

Note:- I already know that most of the part is dependent on the developer itself like the developer's application of the queries to retrieve data, creating indexes etc. But here i am looking for an optimized database where it can handle huge no. of request per minute over the internet.

Please feel to ask any specification you want to know about the question.

Thanks in advance

Posted 27-Jan-16 17:30pm

agent_kruger

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RDBurmon · Accepted Answer · 2016-01-27T18:22:00

Solution 1

If you are looking for simplicity in retrieving the data then SQL SERVER is best

Offcourse, performance of query is purely depends on how you fine tune the database and how you write your query

For example, below query will definitely be slow -

SQL

select * from table1 t1 where t1.Id in (select t2.id from table2)

but If I fine tune the query as shown below then it will run faster

SQL

select distinct t1.* from table1 t1 INNER JOIN table2 t2 ON t1.id=t2.id

Posted 27-Jan-16 18:22pm

RDBurmon

Comments

agent_kruger 28-Jan-16 2:10am

i have used SQL Server for 3 years now but i have heard that where the SQL performance ends there Oracle performance starts. Is this real?

RDBurmon 28-Jan-16 6:52am

Read this document-
http://www.oracle.com/technetwork/database/availability/ha-oracle12c-sqlserver2012-2049933.pdf