For an example, here are the values that I recieved on my 486sx33 (just the percents) from the example program:

As you can see from this example data (Run it on your machine... Cache and graphics cards make a big difference), the compiled sprites are faster when they are mostly transparent. Why is this? It is because the compiled sprites transfer data to memory in bite (byte) sized chunks using offsets, while the standard sprite is using a rep movs instruction. It is paying less for the instruction fetch because it only has to read one instruction from CS for each line. Anyways, enjoy compiled sprites, and don't overindulge!

PROGRAM SpriteExample;
USES GraphPro, Sprite, Timer;
VAR
  SprNum : INTEGER;
  S : ARRAY[1..3] OF SpriteType;
  I            : INTEGER;

  T1T, T1S,   { Test 1 Time, Test 1 Size }
  T2T, T2S,   { Test 2 Time, Test 2 Size }
  T3T, T3S : ARRAY[1..3] OF REAL; { Sprites types 1..3 }

CONST
  Size = 63;
BEGIN
  InitGraph;
  StartTimer(1000);  { 1000 ticks per second... Accurate timer! }

  { Do the first test...                                      }
  ClrScr(0);
  FOR I := 0 TO Size SHR 1 DO                         { Ball sprite }
  BEGIN
    Line(Size SHR 1, I, I, Size SHR 1, 16+I);
    Line(Size SHR 1+1, I, Size-I, Size SHR 1, 16+I);
    Line(Size SHR 1, Size-I, I, Size SHR 1+1, 16+I);
    Line(Size SHR 1+1, Size-I, Size-I, Size SHR 1+1, 16+I);
  END;

  GetSprite(S[1], 0, 0, Size, Size);
  GetSprite(S[2], 0, 0, Size, Size);
  GetSprite(S[3], 0, 0, Size, Size);

  T1S[1] := S[1].DataLen;
  ConvertSpriteToRLE(S[2]);
  T1S[2] := S[2].DataLen;
  ConvertSpriteToCompiled(S[3]);
  T1S[3] := S[3].DataLen;

  FOR SprNum := 1 TO 3 DO
  BEGIN
    Time := 0;
    FOR I := 0 TO 319-Size DO
      DrawSprite(S[SprNum], I, (SprNum-1)*(Size+2));

    T1T[SprNum] := Time;
    T1T[SprNum] := T1T[SprNum] / 1000 / (320-Size); { Do not include division in time }
  END;

  { Do the second test...                                      }
  ClrScr(0);
  FOR I := 0 TO Size SHR 1 DO            { Checkerboard sprite }
  BEGIN
    Line(I*2, 0, Size, Size - I*2, 16+I);
    Line(0, I*2, Size - I*2, Size, 16+I);
  END;

  GetSprite(S[1], 0, 0, Size, Size);
  GetSprite(S[2], 0, 0, Size, Size);
  GetSprite(S[3], 0, 0, Size, Size);

  T2S[1] := S[1].DataLen;
  ConvertSpriteToRLE(S[2]);
  T2S[2] := S[2].DataLen;
  ConvertSpriteToCompiled(S[3]);
  T2S[3] := S[3].DataLen;

  FOR SprNum := 1 TO 3 DO
  BEGIN
    Time := 0;
    FOR I := 0 TO 319-Size DO
      DrawSprite(S[SprNum], I, (SprNum-1)*(Size+2));
    T2T[SprNum] := Time;
    T2T[SprNum] := T2T[SprNum] / 1000 / (320-Size); { Do not include division in time }
  END;

  { Do the second test...                                      }
  ClrScr(0);
  FOR I := 0 TO Size DO            { Checkerboard sprite }
    Line(I, 0, I, Size, 16+I);

  GetSprite(S[1], 0, 0, Size, Size);
  GetSprite(S[2], 0, 0, Size, Size);
  GetSprite(S[3], 0, 0, Size, Size);

  T3S[1] := S[1].DataLen;
  ConvertSpriteToRLE(S[2]);
  T3S[2] := S[2].DataLen;
  ConvertSpriteToCompiled(S[3]);
  T3S[3] := S[3].DataLen;

  FOR SprNum := 1 TO 3 DO
  BEGIN
    Time := 0;
    FOR I := 0 TO 319-Size DO
      DrawSprite(S[SprNum], I, (SprNum-1)*(Size+2));
    T3T[SprNum] := Time;
    T3T[SprNum] := T3T[SprNum] / 1000 / (320-Size); { Do not include division in time }
  END;

  EndTimer;
  CloseGraph;

  WRITELN('Summary of gathered data for ', Size+1,'x', Size+1, ' sprite: ');
  WRITELN;
  WRITELN('                                       Time (s)   | Size  | Time %');

  WRITELN('Test #1 - Ball, typical application');
  WRITELN('Standard:                             ', T1T[1]:2:9, ' |', T1S[1]:6:0,
    ' | ', T1T[1]/T1T[1]*100:3:2, '%');
  WRITELN('RLE     :                             ', T1T[2]:2:9, ' |', T1S[2]:6:0,
    ' | ', T1T[2]/T1T[1]*100:3:2, '%');
  WRITELN('Compiled:                             ', T1T[3]:2:9, ' |', T1S[3]:6:0,
    ' | ', T1T[3]/T1T[1]*100:3:2, '%');
  WRITELN;

  WRITELN('Test #2 - Checkerboard, RLE stress test');
  WRITELN('Standard:                             ', T2T[1]:2:9, ' |', T2S[1]:6:0,
    ' | ', T2T[1]/T2T[1]*100:3:2, '%');
  WRITELN('RLE     :                             ', T2T[2]:2:9, ' |', T2S[2]:6:0,
    ' | ', T2T[2]/T2T[1]*100:3:2, '%');
  WRITELN('Compiled:                             ', T2T[3]:2:9, ' |', T2S[3]:6:0,
    ' | ', T2T[3]/T2T[1]*100:3:2, '%');
  WRITELN;

  WRITELN('Test #3 - Solid, Compiled stress test');
  WRITELN('Standard:                             ', T3T[1]:2:9, ' |', T3S[1]:6:0,
    ' | ', T3T[1]/T3T[1]*100:3:2, '%');
  WRITELN('RLE     :                             ', T3T[2]:2:9, ' |', T3S[2]:6:0,
    ' | ', T3T[2]/T3T[1]*100:3:2, '%');
  WRITELN('Compiled:                             ', T3T[3]:2:9, ' |', T3S[3]:6:0,
    ' | ', T3T[3]/T3T[1]*100:3:2, '%');
  WRITELN;
  WRITE('Press Enter to continue!');
  READLN;
END.