RE: [firebird-support] performance issue with firebird 3.0 embedded on linux

2016-06-20 Thread chen hsu chen...@outlook.com [firebird-support]
to what you tested with Firebird. I got around 28 tx/sec with 8 threads. Have you got chance to run your test on Linux? To: firebird-support@yahoogroups.com From: firebird-support@yahoogroups.com Date: Sat, 18 Jun 2016 10:40:04 +0200 Subject: Re: [firebird-support] performance issue with firebird

Re: [firebird-support] performance issue with firebird 3.0 embedded on linux

2016-06-18 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 15-6-2016 17:55, chen hsu chen...@outlook.com [firebird-support] wrote: > Thanks, Helen. Please see my replies inline. > > I am sure it is not 3.0 specific, 2.5 is the same. and the main issue is > scalability, sequential transaction performance is actually pretty good, > comparable to ESE

RE: [firebird-support] performance issue with firebird 3.0 embedded on linux

2016-06-17 Thread chen hsu chen...@outlook.com [firebird-support]
: [firebird-support] performance issue with firebird 3.0 embedded on linux ---In firebird-support@yahoogroups.com, <chenxuz@...> wrote : > yes, one connection per database, any thread needs to access this database > would >

RE: [firebird-support] performance issue with firebird 3.0 embedded on linux

2016-06-17 Thread hv...@users.sourceforge.net [firebird-support]
---In firebird-support@yahoogroups.com, wrote : > yes, one connection per database, any thread needs to access this database > would > create its own transaction. Then you have serialization at connection level. Both engine and remote layer doesn't allow to run more than

RE: [firebird-support] performance issue with firebird 3.0 embedded on linux

2016-06-16 Thread chen hsu chen...@outlook.com [firebird-support]
@yahoogroups.com Subject: RE: [firebird-support] performance issue with firebird 3.0 embedded on linux Thanks, Helen. Please see my replies inline. I am sure it is not 3.0 specific, 2.5 is the same. and the main issue is scalability, sequential transaction performance is actually pretty good

Re: [firebird-support] performance issue with firebird 3.0 embedded on linux

2016-06-15 Thread 'livius' liviusliv...@poczta.onet.pl [firebird-support]
] performance issue with firebird 3.0 embedded on linux Wednesday, June 15, 2016, 5:58:39 PM, Karol B. wrote: > 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) My project migrated from FB2.5 to FB

RE: [firebird-support] performance issue with firebird 3.0 embedded on linux

2016-06-15 Thread chen hsu chen...@outlook.com [firebird-support]
thread measures its own elapsed time. To: firebird-support@yahoogroups.com From: firebird-support@yahoogroups.com Date: Wed, 15 Jun 2016 19:04:33 +1200 Subject: Re: [firebird-support] performance issue with firebird 3.0 embedded on linux

Re: [firebird-support] performance issue with firebird 3.0 embedded on linux

2016-06-15 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
Wednesday, June 15, 2016, 5:58:39 PM, Karol B. wrote: > 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

Re: [firebird-support] performance issue with firebird 3.0 embedded on linux

2016-06-14 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
Hi,   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

[firebird-support] performance issue with firebird 3.0 embedded on linux

2016-06-14 Thread chen hsu chen...@outlook.com [firebird-support]
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