Click here to Skip to main content
13,198,068 members (50,076 online)
Rate this:
 
Please Sign up or sign in to vote.
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

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

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 -
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
select distinct t1.* from table1 t1 INNER JOIN table2 t2 ON t1.id=t2.id
  Permalink  
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

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

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy |
Web04 | 2.8.171020.1 | Last Updated 28 Jan 2016
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100