According to your application type and needs, the time required for query varies greatly.For applications with high real-time requirements, the shorter the time, the better;For statistical non real-time items, the response time within 10 seconds is generally acceptable. However, if the query needs to process 1 million data lists, such applications may be difficult to meet.Even if only two clients access the server at the same time, the server may not respond in time.In addition, network transmission factors should also be considered.One million pieces of data involve a huge amount of data, even if the number of fields is not too many. Therefore, when designing such a large data processing system, various factors need to be weighed to ensure that the system can efficiently process a large amount of data and meet user needs.
It depends on what kind of application you have. If it is real-time, the shorter the better.If it is a kind of non real-time project, customers should accept it within 10 seconds.However, one query requires one million data lists, which may be difficult to meet.The server cannot respond to a slight increase of two clients.Also consider the network transmission. One million pieces of data are very large, even if your fields are not many.