Emulator

What revision broke it?

In fact I don't know. I tried to play the game with the latest release
but I had bugs. So i Tried some older releases and with release 6175 there is
no appcrash and loadings times are "normals".

EDIT : The newest the release is the longest the loadings are and game crashes
with all the 7xxx releases I tried (appcrash or BEX message after some minutes)
but I don't know why.

"Loadings are VERY longs in Spartan total Warrior (GC)"

Hmm... By curiosity, can you confirm that r7318 is the cause of your problem? (I thought my problem started with r7328, but further testing proved me otherwise...)
To put it simply:
In Pokémon Colosseum (PAL version), for example, r7318 seems to take about 2x as much time as r7317, to go from the first black frame of the last intro video to the actual 3D title screen. I'm quite sure this isn't okay to me...
By the way, this issue doesn't occur when "Speed up disc transfer rate" is enabled, and I am using Mamario's Win32 builds, if that matters.

Either something is wrong with the fix in r7318, or the transfer rate constants should be revised, or everything is okay and this is the correct speed (although I don't think so)...

"By curiosity, can you confirm that r7318 is the cause of your problem?"

Yes I confirm. Loadings times to start the first mission (new game):

r5991 : 1 s (release used in the wiki to test the game)
r6175 : 2 s (the release I use)
r7317 : 5 s
r7318 : 38 s
r7477 : 38 s

Did the crashes begin to happen at the same revision?

No. Although loadings become very long with r7318, the r7317 crashes after 5 minutes playing.

The game often crashes after checkpoints (r7317).
For example, in the mission "The Badlands", the game crashes every time after the first
checkpoint.

The same thing happens with r7318.

I have just found the file exceptioninfo.txt :

Unhandled Exception
Code: 0xC0000005
Call stack info:
ntdll!0x77882D37 : RtlFreeHeap

Unhandled Exception
Code: 0xC0000005
Call stack info:
ntdll!0x77882D94 : RtlFreeHeap

Unhandled Exception
Code: 0xC0000005
Call stack info:
ntdll!0x773B2D37 : RtlFreeHeap

Do the "random" crashes still occur if the "Speed up disc transfer rate" option is ticked in the game properties? Do they still occur using one of the recent revisions? (most likely the answer is yes, but just in case...)

Since you say it is crash-free using (a build of) r6175, and that it crashes with "all of the 7xxx builds you tried" (try being more descriptive here, what's the earliest revision/build you tried that crashed? does r6995 crash as well?), that would mean the "culprit" is between r6176 and insert-buggy-revision-number-here. Try narrowing it down to as few revisions as possible, with "trial and error" (start with r6500, r6700, etc).

(With some luck, issue 4427, issue 4568 and the issue that caused a few RtlFreeHeap crashes for me, may be the same issue...)

It's magical ! With r7589 everything works fine. Loadings are very fasts and I can play the entire mission "The badlands" (I didn't play a long time).
I don't understand...
Problem with loadings is resolved. For the stability, I have to make a longest test.
Good work anyway :)

And yes the "Speed up disc transfer rate" was ticked every time. And r6995 doesn't look to crash (Ialways test with tes same mission).

Oups ! I took a look ar issue 4549 and I think I made a mistake.
In fact I though a "blue square" meant option ticked but it mean option unticked.
And effectivly, with "Speed up disc transfer" truly ticked, loadings are normals.
It's my fault, but the GUI is ambiguous...