From: Nando D. <na...@de...> - 2011-06-30 13:30:09
|
Derryck, > The performance of 3 versions of Flamerobin compared. it seems to me that you are comparing the same query on different data, or Firebird version, or cache state, or other different conditions, as the stats are different in the three cases: 1291 fetches, 0 marks, 555 reads, 0 writes. 0 inserts, 0 updates, 0 deletes, 39 index, 300 seq. Delta memory: 26864 bytes. Execute time: 00:00:01. 17059 fetches, 2 marks, 565 reads, 2 writes. 0 inserts, 0 updates, 0 deletes, 39 index, 8048 seq. Delta memory: 26880 bytes. Total execution time: 0.757s 21549 fetches, 6 marks, 614 reads, 6 writes. 0 inserts, 0 updates, 0 deletes, 233 index, 9872 seq. Delta memory: 38408 bytes. Total execution time: 1.753s -- Nando Dessena |