infobright 中的最大列数
我们在 infobright 表中存储了数十亿行，该表目前约有 45 列。我们想再添加 50 个列。添加这些列会降低读取性能吗？为这些列创建一个新表是更好的选择吗？或者，由于 infobright 是一个面向列的数据库，添加 50 个额外列并不重要？
谢谢！
We store billions of rows in an infobright table which currently has about 45 columns. We want to add 50 more columns to it. Will adding these columns bring down the performance of reads? Is creating a new table for these columns a better option? Or, since infobright is a column oriented database additions of 50 extra columns not matter much?
Thanks!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
我认为“添加这些列”不会“降低不使用添加列的读取性能”。
我认为“为这些列创建一个新表”并不是“更好的选择”。
由于“infobright 是一个面向列的数据库，添加 50 个额外列”应该不会影响不使用添加列的查询的性能。
I think "adding these columns" will not "bring down the performance of reads" that do not use the added columns.
I think "creating a new table for these columns" is not "a better option".
Since "infobright is a column oriented database additions of 50 extra columns" should have no effect on the performance of queries that do not use the added columns.
Infobright6t 表的最大列数为 4096。但是，前提是它们仅为 TINYINT 列。我建议您不要使用超过 1000 列。但关键是确保在 SQL 查询中不执行 SELECT * FROM。您应该 SELECT CustomerID, CustomerName FROM 而不是仅选择那些解决您的需求所必需的列。
The maximum number of columns for Infobrigh6t tables is 4096. However, that is if they are only TINYINT columns. I would suggest that you do not use more than 1000 columns. The key though is ensuring that in your SQL query that you do not do a SELECT * FROM. You should SELECT CustomerID, CustomerName FROM instead for ONLY those columns necessary to resolve your needs.