|Subject||Re: [firebird-support] performance issue with firebird 3.0 embedded on linux|
test without details say nothing to me
1. Did you compare results with e.g. FB2.5 in on the same maschine with same configuration (FBConfig)
2. What is your page size and type of HDD?
3. Do you have BOST feature enabled on CPU and HT?
4. Did you compare results on GLOBAL TEMPORARY TABLE - i know this is not the same but can show some info?
5. How do you test this times about your threads and how do you start them?
6. Exact version of FB
W dniu 2016-06-15 01:44:55 użytkownik chen hsu chenxuz@... [firebird-support] <email@example.com> napisał:
Hi there,Recently I am doing some performance test on firebird 3.0 embedded used in my project. The test is pretty straightforward, on one same table, use 100 insertions per transaction as base test unit (creating a transaction, using a loop to insert 100 records, and committing the transaction), and each test unit is executed on a separate thread. I was trying to see the scalability of firebird with regards to multiple CPUs (each runs a base test unit). But the result is pretty strange, like this:with one cpu, 200 insertion per transaction, 1 transaction in total. each record is 128 bytes.* Finish Insert: total=25600 bytes elapsed=00.244 throughput=104918.032787 bytes/sec, 819.672131 ops/sec, 4.098361 tx/sec succeeded=1with 2 cpus, 200 insertion per transaction, 2 transaction in total. each record is 128 bytes.* Fi nish Insert: total=51200 bytes elapsed=01.807 throughput=28334.255672 bytes/sec, 221.361372 ops/sec, 1.106807 tx/sec succeeded=2with 3 cpus, 200 insertion per transaction, 3 transaction in total. each record is 128 bytes.* Finish Insert: total=76800 bytes elapsed=02.377 throughput=32309.633992 bytes/sec, 252.419016 ops/sec, 1.262095 tx/sec succeeded=3with 4 cpus, 200 insertion per transaction, 4 transaction in total. each record is 128 bytes.* Finish Insert: total=102400 bytes elapsed=05.383 throughput=19022.849712 bytes/sec, 148.616013 ops/sec, 0.743080 tx/sec succeeded=4with 5 cpus, 200 insertion per transaction, 5 transaction in total. each record is 128 bytes.* Finish Insert: total=128000 bytes elapsed=06.428 throughput=19912.881145 bytes/sec, 155.569384 ops/sec, 0.777847 tx/sec succeeded=5with 6 cpus, 200 insertion per transaction, 6 transaction in total. each record is 128 bytes.* Finish Insert: total=153600 bytes elapsed=07.655 throughput=20065.316786 bytes/sec, 156.760287 ops/sec, 0.783801 tx/sec succeeded=6The machine has a 6-core i7 processor. it looks starting from 2 parallel transactions (on 2 CPUs), the performance dropped dramatically from 4 tx/sec to 1.1 ~ 0.7 tx/sec. I tried Super or SuperClassic service configuration, still the same pattern. I am wondering if I missed something in configuration, or it is the known behavior of firebird? Any advice is welcome!Thanks a lot.-chen