3 ms·
I'd guess that it would be slower on Linux by design, but not in a malicious way. They must be using various win32 apis and might have needed to shim them on Li
by eknkc 10y ago
I'd guess that it would be slower on Linux by design, but not in a malicious way. They must be using various win32 apis and might have needed to shim them on Linux. Maybe they had assumptions on NTFS performance, paging behavior etc. All would contribute to a performance difference.
- taspeotis 10y ago> They must be using various win32 apis and might have needed to shim them on Linux Here's a high level overview: http://arstechnica.com/information-technology/2016/12/how-an-old-drawbridge-helped-microsoft-bring-sql-server-to-linux/ http://arstechnica.com/information-technology/2016/12/how-an...
- manigandham 10y agoOfficial blog post from today that shows more details: https://blogs.technet.microsoft.com/dataplatforminsider/2016/12/16/sql-server-on-linux-how-introduction/ https://blogs.technet.microsoft.com/dataplatforminsider/2016...
- NicoJuicy 10y agoIf I'm not mistaking, SQL is an OS on itselve, so it was designed crossplatform from the start
- Someone 10y agoEven if it was, it likely was tuned for, or even built for, only one OS for years. That will have made an impact. For example, if thread creation is faster on an OS, starting threads for smaller tasks becomes a win; if locking primitives are slower, it may be better to take a full-table lock more often.