4 ms·
The timing of the post is interesting given Microsoft SQL Server 2017's new support for Linux. Microsoft's doing it with one code base to span Windows, Linux, a
by BrentOzar 9y ago
The timing of the post is interesting given Microsoft SQL Server 2017's new support for Linux. Microsoft's doing it with one code base to span Windows, Linux, and Azure SQL DB, and it's interesting to read why IBM took a different route.
My favorite line out of it: "so I ended up taking a long weekend and writing support for a primitive approach to supporting greater-than-2GB tables." Wow.
- whatusername 9y agoI'm fairly sure that DB2 for LUW (Linux/Unix/Windows) likely counts as a single code base. And I imagine that's x86 and power (and maybe Sparc? probably big or little endian. And support for Solaris, Aix, etc). It's the esoteric platforms like mainframe or as/400 that need custom code bases
- megaman22 9y agoThat line is especially great in the context of the preceding paragraph: > At the time I was lead architect for the product and felt super-strongly that we needed to address the table size limitation of 2GB before we shipped. I was making that argument vociferously but the excellent counter argument was we were simply out of time. Any reasonable redesign would have delayed us significantly from our committed product ship dates. Estimates ranged from 9 to 12 months and many felt bigger slips were likely if we made changes of this magnitude to the storage engine. >I still couldn’t live with the prospect of shipping a UNIX database product with this scaling limitation so I ended up taking a long weekend and writing support for a primitive approach to supporting greater-than-2GB tables. It's amazing how often one person with a solid grasp of a problem can run circles around teams that are shackled by process and cya and politics.