Is there any practical limit of number of rows a select statement can fetch from a database- any database?
select语句可以从数据库(任何数据库)中获取的行数是否存在实际限制?
Assume, I am running a query SELECT * FROM TableName and that table has more than 12,00,000 rows.
假设，我正在运行一个来自TableName的查询SELECT *，而该表有超过12万行。
How many rows it can fetch? Is there a limit for this?
它能取多少行?这有限制吗?
1 个解决方案
#1
5
12000000 is not at all a big number I have worked with way bigger result sets. As long as your memory can fit the result you should have no problems.
12000000根本不是一个大数字，我用的是更大的结果集。只要你的记忆能符合结果，你就不会有问题。
#1
5
12000000 is not at all a big number I have worked with way bigger result sets. As long as your memory can fit the result you should have no problems.
12000000根本不是一个大数字，我用的是更大的结果集。只要你的记忆能符合结果，你就不会有问题。