.net

[bogeyman]

What's the open source equivalent to SQL Server?

I'm suprised nobody has suggested using a Mac yet.

ScooterScot and CowboyBob are not on the board today. I think they must be cranking one out over the new iPod announcement.

[VectraMan]

What's the open source equivalent to SQL Server?

I'm suprised nobody has suggested using a Mac yet.

[snaw]

And what's wrong with Server 2003 exactly? Solid as a rock in my experience.

I suspect the Microsoft connection bit is what he objects to. Sure if it was open source he be creaming his pants all over it.

[bogeyman]

Must admit I'd be thinking z/OS + DB2 for something that big and mission critical but this Vaughan-Nichols bloke is talking guff of the highest order.

Much as I like MySQL for noddy web backends, I don't think anyone who knows squat about MySQL would seriously recommend it for that kind of project.

And what's wrong with Server 2003 exactly? Solid as a rock in my experience.

[d000hg]

You can use MySQL for "proper" projects, but I don't know about something this big. Apparently eBay use it, they were looking recently to outsource development of some customizations to improve performance for their needs. I was tempted. as it would be a god thing to mention you'd done, but I don't know how DBs actually work internally!

[lilelvis2000]

Well its give all the crap writers in the world hope. You can earn an income writing pure tripe!

[DimPrawn]

Oh, I read the comments... seems he's not getting a lot of respect...

The guys a joke! Use MySql.


http://www.tpc.org/tpce/default.asp

The TPC-E benchmark simulates the OLTP workload of a brokerage firm. The focus of the benchmark is the central database that executes transactions related to the firm’s customer accounts. Although the underlying business model of TPC-E is a brokerage firm, the database schema, data population, transactions, and implementation rules have been designed to be broadly representative of modern OLTP systems.

http://www.tpc.org/tpce/tpce_perf_results.asp

All MS SQL Server on 64 bit Windows.

[oracleslave]

I've built things with MySQL a few times, and it works great, but I thought it was a thing for dinky databases not for anything on the scale of the LSE. Please correct me if I'm wrong.

Sounds about right to me.

[VectraMan]

I've built things with MySQL a few times, and it works great, but I thought it was a thing for dinky databases not for anything on the scale of the LSE. Please correct me if I'm wrong.

[d000hg]

Oh, I read the comments... seems he's not getting a lot of respect...

[d000hg]

Is this just anti-MS guff?

Sorry, Microsoft, .NET Framework is simply incapable of performing this kind of work

I assumed he was going to say that some extremely optimized C++ was required to wring every last cycle out, which is reasonable. But then he goes on to say Java should be used. Java & .NET are comparable in terms of performance.

I don't know about the DB thing, but is SQLServer actually a lot slower than those other DBs? DB2 I'd believe and maybe Informix. But Oracle? and MySQL?!

Come on, get serious. I can accept that for a huge distributed system, Windows maybe doesn't scale so well but I see no problems with .NET or SQLServer.

[swamp]

"What I'd really prefer to see is RHEL (Red Hat Enterprise Linux), JBoss, and MySQL"

I hope he's joking.

[snaw]

I work in the other end of IT so don't profess to know much about these things, but this line kind of enlightened me:

If a customer of mine insisted that they didn't want open source - more fool them

[BlasterBates]

hmm...
.NET