Sql server 临时表记录限制 [英] Temporary table record limit in Sql server

问题描述

临时表中的记录是否有任何限制..我已经尝试了 130 万条记录.. 可能我将来必须根据应用程序的需要处理数十亿条记录.. 可能吗?如果我可以知道记录的限制..我可以尝试从源数据库中拆分记录并在限制内进行管理.提前致谢

Is there any limits for the record in the temporary table.. I have tried with 1.3 million records.. may be i have to deal with billions in the future as the application demands.. Is it possible? If i could know the limit of records.. i could try to split the records from source db and manage within the limit. Thanks in advance

推荐答案

tempdb 与任何其他数据库之间的差异很小，尤其是在限制方面.

The differences between tempdb and any other database are minimal, especially when it comes to limits.

如果您可以将其存储在用户表中，那么您也可以将其存储在临时表中.它不必适合 RAM，因为 tempdb 就像任何其他数据库一样存储在磁盘上(只有更积极的缓存和更少的日志记录).

If you can store it in a user table, you can store it in a temporary table as well. It does not have to fit into RAM as the tempdb is stored on disk just like any other database (only with more aggressive caching and less logging).

来源:http://msdn.microsoft.com/en-us/图书馆/ms190768.aspx

这篇关于Sql server 临时表记录限制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！