宽表 mysql [英] WIDE tables mysql

问题描述

我有一个 30000 x 2000 的矩阵，需要放在表格中.但是我不能在一张表中有 2000 个属性，因为它会超出存储限制.将这些属性拆分到不同的表中被认为是一种很好的做法.如果不是，还有什么其他方法可以处理我的情况?

I have a 30000 by 2000 matrix that I need to put in a table. However I can't have 2000 attributes in one table as it would exceed the storage limit. Is splitting these attributes into different tables considered good practice. If not what other methods are there to deal with my situation ?

谢谢，

推荐答案

没有理由不考虑将其拆分为多个表.这种策略称为分区.http://dev.mysql.com/doc/refman/5.1/en/partitioning-overview.html

There's no reason why you shouldn't look at splitting this into multiple tables. Such a strategy is called partitioning. http://dev.mysql.com/doc/refman/5.1/en/partitioning-overview.html

这篇关于宽表 mysql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！