问题描述
我知道这可能是一个非常常见的问题，但我需要知道数据库有： -
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
推荐答案
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
这篇关于最佳在线性能数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！