Game speed: What affects cascade speed? (Level 1000 test)

Interesting, sound like they reworked the checks within the algorithm but could be:

1. Duplicating calls to the "API"
2. Have no index in the DB table used
3. Have some caught error slowing it down.
4. Fetching objects when ids are needed.

Or more simply put, crap I have done/seen in code that slows stuff down. As a bit of an explanation:

1. Would be making the same call more than once, the result is the same and all the second call is doing is making the whole process slower. This is really easy if the code is "duct taped together".
2. Basically means the search of the DB can go from minutes to seconds since potentially far fewer records need to be searched and the index value does not have to be constantly found in the record itself.
3. Basically this means the code will continue but the whatever causes the error can take time to happen so for example, id 1 is processed and take 2 seconds, 2 is processed, fails after a timeout of 10 seconds then an error appears not stopping the process. Record 3 is processed in 2 seconds and so on.
   So in the end the who process completes but is delayed by the issue with record 2.
4. Basically fetching few bytes of data vs a megabyte or more and all the process it needs.