Re: [firebird-support] Re: How to maximize cpu usage for Firebird?

2013-07-18 Thread Macma
t recommend earlier. Are firebird made some progress between FB 2.5 SS and FB 2.1 SS in this subject? Best Regards, macma

Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

2015-12-29 Thread Macma mac...@wp.pl [firebird-support]

[firebird-support] Query stop working after upgrade from 2.1.5 to 2.1.6

2014-09-02 Thread Macma mac...@wp.pl [firebird-support]
_WYKLADNIK, SI_IDJEDNOSTKA, SI_STPOTYPE, SI_CURRENCYPERVALUE order by max(ke.I_ORDER_INDEX) Any idea how to overcome this issue? Best Regards, macma ++

Re: [firebird-support] Re: Query stop working after upgrade from 2.1.5 to 2.1.6

2014-09-03 Thread Macma mac...@wp.pl [firebird-support]
W dniu 2014-09-03 o 08:31, Dmitry Yemanov dim...@users.sourceforge.net [firebird-support] pisze: > 03.09.2014 09:44, Macma wrote: >> I found that after upgrade from FireBird 2.1.5 Update 1 to 2.1.6 my >> query stop working with error "Dynamic SQL Error SQL error code = -104 &

Re: [firebird-support] Query stop working after upgrade from 2.1.5 to 2.1.6

2014-09-03 Thread Macma mac...@wp.pl [firebird-support]
y (select ID from > >IDY_DO_ZAPYTANIA) > >group by ke.I_ID_GRUPY, ke.C_SYMBOL, C_OPIS_X, SI_WYKLADNIK, > >SI_IDJEDNOSTKA, SI_STPOTYPE, SI_CURRENCYPERVALUE > >order by max(ke.I_ORDER_INDEX) > > > >Any idea how to overcome this issue? > > Hi Macma! > > I w

Re: [firebird-support] Query stop working after upgrade from 2.1.5 to 2.1.6

2014-09-03 Thread Macma mac...@wp.pl [firebird-support]
) group by ke.I_ID_GRUPY, ke.C_SYMBOL, C_OPIS_X, SI_WYKLADNIK, SI_IDJEDNOSTKA, SI_STPOTYPE, SI_CURRENCYPERVALUE order by max(ke.I_ORDER_INDEX) I have to change "where kk.I_ID_KOSZTY = ko.I_ID_KOSZTY" to "kk.I_ID_KOSZTY = any (select ID from IDY_DO_ZAPYTANIA)".

[firebird-support] Firebird backup on virtual machine

2015-08-27 Thread Macma mac...@wp.pl [firebird-support]
Hi, I have to run Firebird 2.5 in Windows 2012R2 on VMware cluster. All VM machines will be regularly backup with Veeam Backup. I red that such backups could cause database file corruption (inconsistency) within the backup. Is there any method to prevent it? May by there is some way to use nbacku

Re: [firebird-support] Firebird backup on virtual machine

2015-08-27 Thread Macma mac...@wp.pl [firebird-support]
Hi, > Veeam should not create file corruptions, but rather the backup of the > database could have data from uncommitted transactions, although > present in the db file, would be ignored by the engine (might show up > in the log file). > My biggest concern was that after restore form Veeam backup

Re: [firebird-support] Firebird backup on virtual machine

2015-08-31 Thread Macma mac...@wp.pl [firebird-support]
W dniu 2015-08-28 o 18:11, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] pisze: > You still need to run the test I outlined... > > Otherwise, you are making several assumptions. The first, is that I am > not a blithering idiot who is spouting nonsense! For now "assumptions" that's all