Re: [firebird-support] Performance of Firebird (Superserver vs Superclassic, etc.)

2014-10-30 Thread 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]
Hi Geoff, Helen Borrie hele...@iinet.net.au [firebird-support] wrote: At 02:36 p.m. 30/10/2014, Geoff Worboys ge...@telesiscomputing.com.au [firebird-support] wrote: Doesn't that depend on how they implemented the separate threads? SS does/can use different threads for separate connections

Odp: [firebird-support] Performance of Firebird (Superserver vs Superclassic, etc.)

2014-10-30 Thread 'liviusliv...@poczta.onet.pl' liviusliv...@poczta.onet.pl [firebird-support]
] firebird-support@yahoogroups.com Do: firebird-support@yahoogroups.com Temat: Odp: [firebird-support] Performance of Firebird (Superserver vs Superclassic, etc.) Data: śr., paź 29, 2014 23:19 There are 46,527 records in the main table, but the calculation touches many other tables. Here

Re: [firebird-support] Performance of Firebird (Superserver vs Superclassic, etc.)

2014-10-30 Thread Geoff Worboys ge...@telesiscomputing.com.au [firebird-support]
'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] wrote: I once did a short video with a very simple/naive SMP capability test across SS and SC. http://www.iblogmanager.com/download/demos/firebird/fb25_architectures_smp.html Although with SS internally requests to the same

Re: [firebird-support] Performance of Firebird (Superserver vs Superclassic, etc.)

2014-10-30 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Oct 29, 2014, at 9:36 PM, Geoff Worboys ge...@telesiscomputing.com.au [firebird-support] firebird-support@yahoogroups.com wrote: Doesn't that depend on how they implemented the separate threads? SS does/can use different threads for separate connections to the same database, can't it?

[firebird-support] Performance of Firebird (Superserver vs Superclassic, etc.)

2014-10-29 Thread t...@camalot.ca [firebird-support]
Thought I would share some experience we have gained recently. We have an application consisting of a C++ Builder front end and Firebird 2.5 as the backend. Running on Windows. The database includes a ton of stored procedures with some fairly intricate calculations. A typical installation

Re: [firebird-support] Performance of Firebird (Superserver vs Superclassic, etc.)

2014-10-29 Thread Thomas Steinmaurer t...@iblogmanager.com [firebird-support]
Hi Todd, Thought I would share some experience we have gained recently. We have an application consisting of a C++ Builder front end and Firebird 2.5 as the backend. Running on Windows. The database includes a ton of stored procedures with some fairly intricate calculations. A typical

Re: Odp: [firebird-support] Performance of Firebird (Superserver vs Superclassic, etc.)

2014-10-29 Thread Thomas Steinmaurer t...@iblogmanager.com [firebird-support]
Hi Todd, There are 46,527 records in the main table, but the calculation touches many other tables. Here is a copy of the analysis of the main procedure from IB Expert: Query Plan Query

Re: [firebird-support] Performance of Firebird (Superserver vs Superclassic, etc.)

2014-10-29 Thread Geoff Worboys ge...@telesiscomputing.com.au [firebird-support]
t...@camalot.ca [firebird-support] wrote: Thought I would share some experience we have gained recently. We have an application consisting of a C++ Builder front end and Firebird 2.5 as the backend. Running on Windows. [...] Also, we had always run Firebird as Superserver. [...]

Re: [firebird-support] Performance of Firebird (Superserver vs Superclassic, etc.)

2014-10-29 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
At 12:59 p.m. 30/10/2014, Geoff Worboys ge...@telesiscomputing.com.au [firebird-support] wrote: Is it safe to assume that, when you were running SuperServer, you had edited firebird.conf to change the installation default CpuAffinityMask from 1 to 15 ? (So that it would use all 4 of your

Re: [firebird-support] Performance of Firebird (Superserver vs Superclassic, etc.)

2014-10-29 Thread Geoff Worboys ge...@telesiscomputing.com.au [firebird-support]
Helen Borrie hele...@iinet.net.au [firebird-support] wrote: At 12:59 p.m. 30/10/2014, Geoff Worboys ge...@telesiscomputing.com.au [firebird-support] wrote: Is it safe to assume that, when you were running SuperServer, you had edited firebird.conf to change the installation default

Re: [firebird-support] Performance of Firebird (Superserver vs Superclassic, etc.)

2014-10-29 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
Helen Borrie hele...@iinet.net.au [firebird-support] wrote: At 12:59 p.m. 30/10/2014, Geoff Worboys ge...@telesiscomputing.com.au [firebird-support] wrote: Is it safe to assume that, when you were running SuperServer, you had edited firebird.conf to change the installation default

Re: [firebird-support] Performance of Firebird (Superserver vs Superclassic, etc.)

2014-10-29 Thread Geoff Worboys ge...@telesiscomputing.com.au [firebird-support]
Helen Borrie hele...@iinet.net.au [firebird-support] wrote: At 02:36 p.m. 30/10/2014, Geoff Worboys ge...@telesiscomputing.com.au [firebird-support] wrote: Doesn't that depend on how they implemented the separate threads? SS does/can use different threads for separate connections to the same