Request advice for performance tuning Firebird db+application
lazarus / 16-Databases

----------------------------------------------------------------------
BigChimp · 2012-12-08 11:04

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.lazar
us.freepascal.org/Jenkins#FPCUnit.2FDBTestframework_tests_with_databas
e_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.