Firebird News

Tuesday, October 26, 2010

Now the benchmark results :Firebird 2.5 seems that clang++ is faster!

clean run , the old llvm results were when the system was under high load
now i have the clean results and seems that clang++ is faster

clean run

running on the g++ (compiled from source)

python ibench1.py --db_user=sysdba --db_password=masterkey
--db_name=/tmp/test.fdb --setup --max_rows=100000 --setup
#rows #seconds cum_ips last_ips #queries cum_qps last_qps
10000 39 257.5 257.5 1920 49.4 49.4
20000 117 171.6 128.6 5376 46.1 44.5
30000 230 130.6 88.4 10469 45.6 45.0
40000 366 109.3 73.4 16763 45.8 46.2
50000 509 98.2 69.7 24325 47.8 52.7
60000 663 90.5 65.2 31234 47.1 45.1
70000 832 84.1 59.1 37080 44.6 34.5
80000 998 80.2 60.2 42211 42.3 30.9
90000 1179 76.4 55.3 47324 40.1 28.3
100000 1372 72.9 51.7 52632 38.4 27.4
Done

clang++ clean

python ibench1.py --db_user=sysdba --db_password=masterkey
--db_name=/tmp/test.fdb --setup --max_rows=100000 --setup
#rows #seconds cum_ips last_ips #queries cum_qps last_qps
10000 30 338.9 338.9 1870 63.4 63.4
20000 91 219.3 162.1 5191 56.9 53.8
30000 179 167.2 113.3 10145 56.5 56.1
40000 294 136.1 87.4 16250 55.3 53.3
50000 469 106.6 57.1 23999 51.2 44.3
60000 639 93.9 58.8 30649 48.0 39.1
70000 798 87.7 62.9 36553 45.8 37.1
80000 957 83.6 63.0 41553 43.4 31.5
90000 1128 79.8 58.4 46852 41.5 30.9
100000 1301 76.9 58.0 51411 39.5 26.4
Done


clang++ fronm ubuntu 10.10

after each run i have run the following scripts

cat killall.sh
sudo killall -9 fbguard
sudo killall -9 fbserver
cat delete.sh
sudo rm -rf /opt/firebird2.5
sudo rm -rf /etc/init.d/firebird
cat config.sh
make clean
rm -rf gen
./configure --prefix=/opt/firebird2.5 --enable-superserver
--with-system-icu --with-system-editline

sudo make install

(in the firebird 2.5 from subversion tree)

ps:
make install doesn't work quite correctly in g++ and clang++ there are
some bugs on ubuntu 10.10
I have to CTRL-C the installer after i put the password , so i will
mark it as bug in jira for both compilers

No comments: