[Info-vax] Apache + mod_php performance

[Arne Vajhøj]

On 9/28/2024 5:33 PM, Lawrence D'Oliveiro wrote:
> On Sat, 28 Sep 2024 09:26:51 -0400, Arne Vajhøj wrote:
>> On 9/28/2024 1:08 AM, Lawrence D'Oliveiro wrote:
>>> On Fri, 27 Sep 2024 22:18:39 -0400, Arne Vajhøj wrote:
>>>> SQLServer is used at a few high volume places like MS own Office 365
>>>> web and StackExchange.
>>>
>>> I wonder if it was used as part of that London Stock Exchange system
>>> that imploded so spectacularly?
>>
>> The TradElect system used by London Stock Exchange 2007-2011 (which was
>> not a success) used SQLServer 2000 as database.
> 
> Not exactly a recommendation for mission-critical use, is it?

The solution did not work well - it went down several times
when load were extraordinary high.

But it has never been documented exactly what the problem was.

SQLServer vs another RDBMS (most likely Oracle DB or IBM DB2) does
not make my top 6 of guesses. SQLServer was a rather mature
product at the time (partly due to Sybase heritage).

My top 6 guesses would be:

1) Implementation team consisting of general consultants
    without domain expertise doing a poor job implementing.
2) The choice of a relative new technology at the time .NET
    for implementation - the version is not known, but
    the system went into production in 2007, so most
    likely the project was started with .NET 1.1 (2003) and
    not .NET 2.0 (2005) - new stuff and critical systems
    is not a good combo because all bugs may not have been
    sorted out yet and  peoples understanding of the new stuff
    may be limited
3) Inadequate hardware to handle unexpected high peak load
4) Decision to use GC language and RDBMS for something that
    is let us call it soft real time
5) Other bad architectural decisions
6) Network issues - just because that was what LSE actually claimed

Arne