comparing MS SQL to MySQL (size)
- Thread starter filtuh.com
- Start date
Upvote
0
From what I can remember about MS SQLServer, it is a very different beast compared to MySQL.
SQLServer is based on the idea of creating data devices and log devices upfront which hold databases and multiple tables etc and are therefore created bigger than required anyway.
MySQL is based more on the underlying file system, with files per table which grow when required.
(SQLServer devices can autogrow too, but in certain sized chunks.)
Just because SQLServer might take up more room, this isn't always a bad thing, as there are reasons and advantages to its approach too, e.g. speed of table growth, performance, better data integrity resilience with its log etc
BTW, transaction logs are not like say web logs, just logging what happens. They are usually a necessary feature to ensure data integrity, resilience, rollbacks, smooth backups etc.
I find it strange that a strategic decision between MS SQLServer and MySQL would be purely based on how big the underlying file sizes are.
SQLServer is based on the idea of creating data devices and log devices upfront which hold databases and multiple tables etc and are therefore created bigger than required anyway.
MySQL is based more on the underlying file system, with files per table which grow when required.
(SQLServer devices can autogrow too, but in certain sized chunks.)
Just because SQLServer might take up more room, this isn't always a bad thing, as there are reasons and advantages to its approach too, e.g. speed of table growth, performance, better data integrity resilience with its log etc
BTW, transaction logs are not like say web logs, just logging what happens. They are usually a necessary feature to ensure data integrity, resilience, rollbacks, smooth backups etc.
I find it strange that a strategic decision between MS SQLServer and MySQL would be purely based on how big the underlying file sizes are.
Last edited:
Upvote
0
Latest Articles
-
At What Point Do Courier Losses Just Become a Cost of Doing Business?If you sell physical products online, you already know the feeling. You...- Ozzy
- Updated:
-
What I Wish I'd Known Before Using AI in My BusinessSomewhere between the headlines promising AI will transform everything...
- Ozzy
- Updated:
-
Is AI Making the Internet Worse?It started with a comment about music. @JEREMY HAWKE , a courier...
- Ozzy
- Updated:
-
The AI Divide: What UKBF Members Really Think in 2026Every few months on UK Business Forums, a thread appears that refuses...
- Ozzy
- Updated:
-
When the Algorithm Gets It Wrong: What eBay's AI Moderation Problem Tells Us About Platform RiskA thread appeared on UKBF this week that, on the surface, looks like a...
- Ozzy
- Updated:
