Home  >  Article  >  Database  >  mysql-关于数据表的优化及转换问题?

mysql-关于数据表的优化及转换问题?

WBOY
WBOYOriginal
2016-06-06 09:39:491039browse

mysql优化mssql

A表600M,有ntext列,记录15万条
B表6000M,有ntext列,记录15万条

其它列都几乎相同并且没有占多字节的列

这种情况是不是说明B表中多数ntext列都存储N倍于A表的内容?

两个表都需要如何优化吗?如何优化?

原数据库为mssql,如何把mssql转换成mysql(myisam)?

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn