Mit DELETE FROM, Tabellen sind leer

Benchmark: timing 50000000 iterations of AutoIncr, Redesign...
  AutoIncr:  0 wallclock secs ( 1.58 usr +  0.00 sys =  1.58 CPU) @ 31685678.07/s (n=50000000)
  Redesign:  0 wallclock secs ( 0.12 usr + -0.01 sys =  0.11 CPU) @ 454545454.55/s (n=50000000)
            (warning: too few iterations for a reliable count)
                Rate AutoIncr Redesign
AutoIncr  31685678/s       --     -93%
Redesign 454545455/s    1335%       --

Ohne DELETE FROM
Benchmark: timing 50000000 iterations of AutoIncr, Redesign...
  AutoIncr:  3 wallclock secs ( 2.53 usr +  0.00 sys =  2.53 CPU) @ 19747235.39/s (n=50000000)
  Redesign:  0 wallclock secs ( 0.06 usr +  0.00 sys =  0.06 CPU) @ 806451612.90/s (n=50000000)
            (warning: too few iterations for a reliable count)
                Rate AutoIncr Redesign
AutoIncr  19747235/s       --     -98%
Redesign 806451613/s    3984%       --




Wiederholung:
Benchmark: timing 50000000 iterations of AutoIncr, Redesign...
  AutoIncr:  1 wallclock secs ( 1.02 usr +  0.00 sys =  1.02 CPU) @ 49261083.74/s (n=50000000)
  Redesign:  1 wallclock secs ( 1.00 usr +  0.00 sys =  1.00 CPU) @ 50000000.00/s (n=50000000)
               Rate AutoIncr Redesign
AutoIncr 49261084/s       --      -1%
Redesign 50000000/s       1%       --