The size of MySQL and SQL Server databases [closed]
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.
精彩评论