Performance getting worse per release !

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Performance getting worse per release !

derryck welas-2
Hi All,

The performance  of 3 versions  of Flamerobin compared.

FRobin 0.9.0.xx

Starting transaction...
Preparing query: SELECT a.SEQ_NR, a.TABLE_NAME, a.TRANTYPE, a.UPDDATE, a.OBJECT_SEQ_NR, a.REPL_STATUS, a.ERROR_CODE, a.ERROR_MSG
FROM CHANGE_LOG a
Prepare time: 00:00:01.
Field #01: CHANGE_LOG.SEQ_NR Alias:SEQ_NR Type:INTEGER
Field #02: CHANGE_LOG.TABLE_NAME Alias:TABLE_NAME Type:STRING(100)
Field #03: CHANGE_LOG.TRANTYPE Alias:TRANTYPE Type:STRING(1)
Field #04: CHANGE_LOG.UPDDATE Alias:UPDDATE Type:TIMESTAMP
Field #05: CHANGE_LOG.OBJECT_SEQ_NR Alias:OBJECT_SEQ_NR Type:STRING(100)
Field #06: CHANGE_LOG.REPL_STATUS Alias:REPL_STATUS Type:STRING(1)
Field #07: CHANGE_LOG.ERROR_CODE Alias:ERROR_CODE Type:STRING(100)
Field #08: CHANGE_LOG.ERROR_MSG Alias:ERROR_MSG Type:STRING(255)
PLAN (A NATURAL)


Executing...
Done.
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.
Script execution finished.
Commiting transaction...
Done.




FRobin 0.9.2.



Starting transaction...
Preparing query: SELECT a.SEQ_NR, a.TABLE_NAME, a.TRANTYPE, a.UPDDATE, a.OBJECT_SEQ_NR, a.REPL_STATUS, a.ERROR_CODE, a.ERROR_MSG
FROM CHANGE_LOG a
Prepare time: 0.184s
Field #01: CHANGE_LOG.SEQ_NR Alias:SEQ_NR Type:INTEGER
Field #02: CHANGE_LOG.TABLE_NAME Alias:TABLE_NAME Type:STRING(100)
Field #03: CHANGE_LOG.TRANTYPE Alias:TRANTYPE Type:STRING(1)
Field #04: CHANGE_LOG.UPDDATE Alias:UPDDATE Type:TIMESTAMP
Field #05: CHANGE_LOG.OBJECT_SEQ_NR Alias:OBJECT_SEQ_NR Type:STRING(100)
Field #06: CHANGE_LOG.REPL_STATUS Alias:REPL_STATUS Type:STRING(1)
Field #07: CHANGE_LOG.ERROR_CODE Alias:ERROR_CODE Type:STRING(100)
Field #08: CHANGE_LOG.ERROR_MSG Alias:ERROR_MSG Type:STRING(255)
PLAN (A NATURAL)


Executing...
Done.
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
Script execution finished.
Commiting transaction...
Done.


FRobin  0.9.3.2106


Starting transaction...
Preparing query: SELECT a.SEQ_NR, a.TABLE_NAME, a.TRANTYPE, a.UPDDATE, a.OBJECT_SEQ_NR, a.REPL_STATUS, a.ERROR_CODE, a.ERROR_MSG
FROM CHANGE_LOG a
Prepare time: 0.174s
Field #01: CHANGE_LOG.SEQ_NR Alias:SEQ_NR Type:INTEGER
Field #02: CHANGE_LOG.TABLE_NAME Alias:TABLE_NAME Type:STRING(100)
Field #03: CHANGE_LOG.TRANTYPE Alias:TRANTYPE Type:STRING(1)
Field #04: CHANGE_LOG.UPDDATE Alias:UPDDATE Type:TIMESTAMP
Field #05: CHANGE_LOG.OBJECT_SEQ_NR Alias:OBJECT_SEQ_NR Type:STRING(100)
Field #06: CHANGE_LOG.REPL_STATUS Alias:REPL_STATUS Type:STRING(1)
Field #07: CHANGE_LOG.ERROR_CODE Alias:ERROR_CODE Type:STRING(100)
Field #08: CHANGE_LOG.ERROR_MSG Alias:ERROR_MSG Type:STRING(255)
PLAN (A NATURAL)


Executing...
Done.
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
Script execution finished.



Derryck


------------------------------------------------------------------------------
All of the data generated in your IT infrastructure is seriously valuable.
Why? It contains a definitive record of application performance, security
threats, fraudulent activity, and more. Splunk takes this data and makes
sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-d2d-c2
_______________________________________________
Flamerobin-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/flamerobin-devel
Reply | Threaded
Open this post in threaded view
|

Re: Performance getting worse per release !

Nando Dessena
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


------------------------------------------------------------------------------
All of the data generated in your IT infrastructure is seriously valuable.
Why? It contains a definitive record of application performance, security
threats, fraudulent activity, and more. Splunk takes this data and makes
sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-d2d-c2
_______________________________________________
Flamerobin-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/flamerobin-devel
Reply | Threaded
Open this post in threaded view
|

Re: Performance getting worse per release !

Milan Babuskov-4
In reply to this post by derryck welas-2
On Thu, Jun 30, 2011 at 3:03 PM, Derryck welas <[hidden email]> wrote:
> The performance  of 3 versions  of Flamerobin compared.

None of these compares versions of FlameRobin, but rather versions of
Firebird or of your database. Most probably the accumulated garbage in
the database. The only way to ensure you are running the same query is
to reuse the database file.

If you really wanted to profile FR, you would need to take a copy of
some database file and repeat this process:

1. install desired version of FR
2. copy database file to a new location
3. reboot
4. test on the new copy

My bet is that you'll get very similar results for each run.

--
Milan Babuskov
http://www.guacosoft.com

------------------------------------------------------------------------------
All of the data generated in your IT infrastructure is seriously valuable.
Why? It contains a definitive record of application performance, security
threats, fraudulent activity, and more. Splunk takes this data and makes
sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-d2d-c2
_______________________________________________
Flamerobin-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/flamerobin-devel