问题描述
我开发的软件将大量数据存储在其数据库表（SQL Server版本8,9或10）中。假设每天大约有10万条记录插入该表中。每年约有3600万条记录。为了担心我会失去表演，我决定每天创建一个新的表格（一个名称为当前日期的表格），以降低每张表格的记录数量。
感谢您的回答。
很难给出一个通用的答案。这真的取决于多少因素：
- 你的行是什么尺寸
- 什么样的数据你存储（字符串，blob，数字）
- 你如何处理数据（只需保存为存档，定期查询）
- 您的表上有索引 - 有多少
- 您的服务器规格是多少
等
正如这里的其他地方所述，每天100,000次，因此每张桌子都是过度的 - 我建议每月或每周甚至每季度。越多的表格就会变得越来越多的维护/查询恶梦。
I develop software that stores a lot of data in one of its database tables (SQL Server version 8, 9 or 10). Let's say, about 100,000 records are inserted into that table per day. This is about 36 million records per year. For fear that I would lose on performance, I decided to create a new table everyday (a table with current date in its name) to lower the number of records per table.
Could you please tell me, whether it was a good idea? Is there a record limit for SQL server tables? Or do you know how many records (more or less) can be stored in a table before performance is lowered significantly?
Thanks for your answers in advance.
It's hard to give a generic answer to this. It really depends on number of factors:
- what size your row is
- what kind of data you store (strings, blobs, numbers)
- what do you do with your data (just keep it as archive, query it regularly)
- do you have indexes on your table - how many
- what's your server specs
etc.
As answered elsewhere here, 100,000 a day and thus per table is overkill - I'd suggest monthly or weekly perhaps even quarterly. The more tables you have the bigger maintenance/query nightmare it will become.
这篇关于SQL Server：表中的最大行数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！