Recent

Author Topic: Request advice for performance tuning Firebird db+application  (Read 3255 times)

BigChimp

  • Hero Member
  • *****
  • Posts: 5740
  • Add to the wiki - it's free ;)
    • FPCUp, PaperTiger scanning and other open source projects
Request advice for performance tuning Firebird db+application
« on: December 08, 2012, 12:04:00 pm »
Hi all,

I've been working on an fpcunit listener that writes fpcunit test results to a database instead of an XML file: handy to be able to compare results between runs and detect regressions.

My aim was to make the code cross-database friendly (using portable SQL) and normalize the database so it can be used for a lot of test results (e.g. in Continuous Integration server kicked off by SVN commits).

I've been using it with a remote Firebird database server in my Jenkins CI server for the dbtestframework tests (see http://wiki.lazarus.freepascal.org/Jenkins#FPCUnit.2FDBTestframework_tests_with_database_output)

By now, I think I've got the test listener code working well from a functional perspective and I'm now looking at improving performance without sacrificing storage size/normalization.

Any hints/tips on both the code and the Firebird DDL are very welcome. The code right now is a bit of a big chunk and could very well be simplified.

Code including database schema (for convenience, the code can autocreate and use a Firebird embedded database):
https://bitbucket.org/reiniero/testdbwriter/downloads (select tag:tip to download the latest code)

Thanks.
Want quicker answers to your questions? Read http://wiki.lazarus.freepascal.org/Lazarus_Faq#What_is_the_correct_way_to_ask_questions_in_the_forum.3F

Open source including papertiger OCR/PDF scanning:
https://bitbucket.org/reiniero

Lazarus trunk+FPC trunk x86, Windows x64 unless otherwise specified

 

TinyPortal © 2005-2018