Originally by: Little Fistter

---

Originally by: Angua Forres

---

Why do CCP use MS SQL Server? MySQL's much faster, and you can fix stuff like this yourself (Or let the enterprise support guys do that for you- they're really, really good at what they do compared to the spammed generic responses MS SQL Support people give you).

Hell if I know why CCP use Microsoft Server anyway, Linux is much better at their sort of operation by design, from the kernel down....

---

I too, like Minux and MySQL, but. YOU do not have half a clue what you are talking about. No SQL server is as quick as Microsoft's SQL Server, and damn few are as reliable after a crash. (Oracle, IBM and MS are the only ones that reliably roll-back transactions to obtain a correct state.)

Oracle and IBM are very expensive and not any faster on commercially-available hardware (IBM and Oracle have some super computer apps but they are very tweaked for special hardware.)

Now, once we establish that the choice of platform is not the problem, we need to ask, what is causing the lockup? I believe the answer is obvious.

The large Alliances definitely know how to cause lag.

I have seen 300 pilots in Jita cause lag and I have seen 100 or so fleet pilots lag a system. The 100 fleet pilots cause a lot more lag. How they do it it a secret and I do not have a clue... it was suggested that the fleet causes lag by moving large amounts of bookmarks, but no one who knows will say exactly how they do it, but I have seen the results and the lag is extreme.

I think they do it by causing database transactions to queue up. Look at the times your database is crashing then look at where alliances were at that time. I bet you will find some high numbers of non-critical database functions associated with some large fleet engaging another large fleet, I have recently seen SNIGG and GOONSWARM use such tactics, they had maybe ten pilots in a 0.0 system with almost no one else yet they were able to lag the system badly for about 20 minutes. It was not them playing by the rules that caused the lag.

Bottom line: Someone is exploiting database calls to lag our systems. Hope you catch them.

---