Wednesday, October 20, 2010

clang++ production tests (fbench) with Firebird 2.5 part two

I have ran a new set of benchmarks at Phillipe's suggestion (with some minor tweaks to the fbench script)
and all finished ok
sudo apt-get install python-configglue
sudo apt-get install python-configobj

svn co https://firebird.svn.sourceforge.net/svnroot/firebird/qa/trunk/benchmark/
cd benchmark/

cp fbenchdb.fbk /tmp/

Restore it with flamerobin or any other tool
in /tmp/fbenchdb.fdb

./fbenchrun.py /tmp/fbenchdb.fdb 
Database  /tmp/fbenchdb.fdb
Running ComputeClient 5x100000 . . . . . .
Running ComputeClientProxy 5x100000 . . . . . .
Running ComputeServer 5x1 . . . . . .
Running ComputeServerProxy 5x1 . . . . . .
Running ComputeServerProxyNofetch 5x1 . . . . . .
Running GeneratorClient 5x100000 . . . . . .
Running GeneratorClientProxy 5x100000 . . . . . .
Running GeneratorServer 5x1 . . . . . .
Running GeneratorServerProxy 5x1 . . . . . .
Running GeneratorServerProxyNofetch 5x1 . . . . . .
Running GeneratorTableClient 5x100000 . . . . . .
Running GeneratorTableClientProxy 5x100000 . . . . . .
Running GeneratorTableServer 5x1 . . . . . .
Running GeneratorTableServerProxy 5x1 . . . . . .
Running GeneratorTableServerProxyNofetch 5x1 . . . . . .
Calibrating Index2AndFilterAll ... set to  100  iterations.
Running Index2AndFilterAll 5x100 . . . . . .
Calibrating Index2AndFilterOne ... set to  100  iterations.
Running Index2AndFilterOne 5x100 . . . . . .
Calibrating Index2OrFilterAll ... set to  10  iterations.
Running Index2OrFilterAll 5x10 . . . . . .
Calibrating Index2OrFilterOne ... set to  100  iterations.
Running Index2OrFilterOne 5x100 . . . . . .
Calibrating Index3OrAndFilterAll ... set to  10  iterations.
Running Index3OrAndFilterAll 5x10 . . . . . .
Calibrating Index3OrAndFilterOne ... set to  100  iterations.
Running Index3OrAndFilterOne 5x100 . . . . . .
Calibrating IndexFilterAll ... set to  100  iterations.
Running IndexFilterAll 5x100 . . . . . .
Calibrating IndexFilterOne ... set to  100  iterations.
Running IndexFilterOne 5x100 . . . . . .
Calibrating JoinAll ... set to  1  iterations.
Running JoinAll 5x1 . . . . . .
Calibrating JoinOne ... set to  100  iterations.
Running JoinOne 5x100 . . . . . .
Calibrating NaturalFilterAll ... set to  1  iterations.
Running NaturalFilterAll 5x1 . . . . . .
Calibrating NaturalFilterOne ... set to  10  iterations.
Running NaturalFilterOne 5x10 . . . . . .
Calibrating NaturalFullAll ... set to  1  iterations.
Running NaturalFullAll 5x1 . . . . . .
Calibrating NaturalFullOne ... set to  100  iterations.
Running NaturalFullOne 5x100 . . . . . .
Calibrating OrderAll ... set to  1  iterations.
Running OrderAll 5x1 . . . . . .
Calibrating OrderOne ... set to  1  iterations.
Running OrderOne 5x1 . . . . . .
Calibrating SortAll ... set to  1  iterations.
Running SortAll 5x1 . . . . . .
Calibrating SortOne ... set to  1  iterations.
Running SortOne 5x1 . . . . . .

3 comments:

Unknown said...

poate e off topic dar , ai cumva si un how to de build Firebird 2.5 pe FreeBSD 7.x?
din cate se stie e portat doar pana la versiunea 2.0.3 poate reusesti sa faci si un how-to.
Mersi.

Popa Adrian Marius said...

este ceva patch pt firebird 2.1.x din threadul respectiv o sa fac si un howto/port pt firebird 2.5

mi s-a umplut discul in masina virutala si trebuie sa reinstalez din nou freebsd 8.x , pe kvm/libvirt nu a mers cum trebuie si tot asa de aia nu am reusit sa termin howto-ul , insa reinstalez si o sa recompilez firebird-ul ..., adaug patch-uri la port

Popa Adrian Marius said...

aici e thread-ul cu compilarea pe freebsd

http://forums.freebsd.org/showpost.php?p=105302&postcount=13