开发者

The size of MySQL and SQL Server databases [closed]

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. 开发者_运维知识库 Closed 10 years ago.

When storing data in MySQL and storing the same data in SQL Server, will the size of the database differs or will it be the same for both?

Updated: What I mean exactly if we have 20 GB of disk space, and we used both SQL Server and MySQL and stored the same data exactly for example, texts, dates. All data were the same exactly in both databaes, then will the size of both be the same?


The size of the DB on disk is entirely implementation dependent, so it will likely be different. If it's not, it's just a fluke. It is also something that you shouldn't really worry about. Just buy enough disk.


It depends on many factors: block/page size, kind of data, kind of tables, type of indexes, recovery model (ms sql), data types and so on and so on.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜