最佳在线性能数据库 [英] Best online performance database

问题描述

我知道这可能是一个非常常见的问题，但我需要知道数据库有： -



1. 最佳性能 （不是谈论代码的应用，而是谈论我们何时只是从数据库中检索数据从Table1中选择A）

2.可以处理大量数据（每分钟可能会收到1,00,000个查询或更多）



注意： - 我已经知道大部分内容都依赖于开发人员本身就像开发人员的查询应用程序来检索数据，创建索引等。但在这里，我正在寻找一个优化的数据库，它可以处理巨大的数据。通过互联网每分钟的请求。



请询问您想要了解的有关该问题的任何规格。



提前致谢

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

推荐答案

如果您正在寻找简单的检索数据，那么SQL SERVER是最好的



Offcourse，performance查询完全取决于你如何微调数据库以及如何编写查询



例如，下面的查询肯定会很慢 -

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

这篇关于最佳在线性能数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！