[firebird-support] RE: High "Mutex wait" value, after increase in "Hash Slots" to 90001

2017-03-10 Thread 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
I forgot to add, the disk subsystem that the database running on supports 200,000+ 8KB IOPS, so slow disk performance is not likely. > We have a client with 320GB database (running FB CS v2.5) reporting > performance issues, while we are investigating possible application sources, I > have been

[firebird-support] High "Mutex wait" value, after increase in "Hash Slots" to 90001

2017-03-10 Thread 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
We have a client with 320GB database (running FB CS v2.5) reporting performance issues, while we are investigating possible application sources, I have been reviewing their Firebird config. Yesterday, I ran fb_lock_print to check on the database and found a "Mutex wait" value of 20.9%, which

Re: [firebird-support] Interbase vs Firebird

2017-03-10 Thread 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]

Re: [firebird-support] Re: FB 3 embedded on Windows 7 64 bit

2017-03-10 Thread hv...@users.sourceforge.net [firebird-support]
---In firebird-support@yahoogroups.com, wrote : On 10.03.2017 15:35, hvlad@... mailto:hvlad@... [firebird-support] wrote: > So setting FIREBIRD environment variable is the correct and only way to > define the Firebird/plugin path at runtime? Correct - yes, only - no

Re: [firebird-support] Re: FB 3 embedded on Windows 7 64 bit

2017-03-10 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2017-03-10 14:56, Martin Schreiber mse00...@gmail.com [firebird-support] wrote: > On 10.03.2017 15:35, hv...@users.sourceforge.net [firebird-support] > wrote: > > > > > > ---In firebird-support@yahoogroups.com, wrote : > > > > > >> Are ther other possibilities to set the

Re: [firebird-support] Re: FB 3 embedded on Windows 7 64 bit

2017-03-10 Thread Martin Schreiber mse00...@gmail.com [firebird-support]
On 10.03.2017 15:35, hv...@users.sourceforge.net [firebird-support] wrote: > > > ---In firebird-support@yahoogroups.com, wrote : > > >> Are ther other possibilities to set the Firebird path than setting >> %FIREBIRD%? A parameter to attachDatabase() maybe? > >

[firebird-support] Re: FB 3 embedded on Windows 7 64 bit

2017-03-10 Thread hv...@users.sourceforge.net [firebird-support]
---In firebird-support@yahoogroups.com, wrote : > Are ther other possibilities to set the Firebird path than setting > %FIREBIRD%? A parameter to attachDatabase() maybe? SetEnvironmentVariable.

[firebird-support] Re: FB 3 embedded on Windows 7 64 bit

2017-03-10 Thread Martin Schreiber mse00...@gmail.com [firebird-support]
On 10.03.2017 08:41, Martin Schreiber wrote: > Hi, > I want to use FB 3 in embedded mode in an application: > https://gitlab.com/mseide-msegui/mseuniverse/wikis/msekicadbom/MSEkicadBOM > (under construction). > It works well on Linux. On Windows 7 64 bit I installed >

Re: [firebird-support] Re: Interbase vs Firebird

2017-03-10 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
10.03.2017 13:59, lis...@warmboot.com.br [firebird-support] wrote: > If you are speaking about Change Views feature, I understand its main > purpose is to help mobile applications to update local copies of > (changed) data easily. Yes, this is the main purpose of Change View (sorry, I messed

Re: [firebird-support] Re: Interbase vs Firebird

2017-03-10 Thread Pavel Cisar pci...@ibphoenix.cz [firebird-support]
Hi, Dne 10.3.2017 v 13:59 lis...@warmboot.com.br [firebird-support] napsal(a): > If you are speaking about Change Views feature, I understand its main > purpose is to help mobile applications to update local copies of > (changed) data easily. Similar thing could be implemented in your app.

[firebird-support] Re: Interbase vs Firebird

2017-03-10 Thread lis...@warmboot.com.br [firebird-support]
If you are speaking about Change Views feature, I understand its main purpose is to help mobile applications to update local copies of (changed) data easily. []s Carlos Migration Guide to Firebird 3 - http://www.firebirdnews.org/migration-guide-to-firebird-3/

Re: [firebird-support] Interbase vs Firebird

2017-03-10 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
10.03.2017 9:39, 'liviusliv...@poczta.onet.pl' liviusliv...@poczta.onet.pl [firebird-support] wrote: > But there is some performance/scaling problem showed and i am interested > about your opinion It is funny that they think that their Changes Tracking API can be used for replication of

[firebird-support] FB 3 embedded on Windows 7 64 bit

2017-03-10 Thread Martin Schreiber mse00...@gmail.com [firebird-support]
Hi, I want to use FB 3 in embedded mode in an application: https://gitlab.com/mseide-msegui/mseuniverse/wikis/msekicadbom/MSEkicadBOM (under construction). It works well on Linux. On Windows 7 64 bit I installed Firebird-3.0.1.32609_0_x64.exe When I set %FIREBIRD% to the FB install directory

[firebird-support] Interbase vs Firebird

2017-03-10 Thread 'liviusliv...@poczta.onet.pl' liviusliv...@poczta.onet.pl [firebird-support]
Hi, I got info from Embarcadero ;-) https://www.embarcadero.com/products/interbase/compare/interbase_firebird Yes i know this is sales advertisement. And if we compare what Firebird have and Interbase have not ... But there is some performance/scaling problem showed and i am interested about