Re: [firebird-support] Off-Topic: Firebird future

2019-10-21 Thread 'Alexey Kovyazin (ak)' a...@ib-aid.com [firebird-support]
Hello Stefan, If Firebird users want to have GUI too, we should consider the options. The situation now is really different than several years ago, so including a free GUI to Firebird umbrella now is really a option. For example, at Firebird Conference there was presentation about RedExpert -

Re: [firebird-support] Scaling Firebird - Azure

2019-10-09 Thread 'Alexey Kovyazin (ak)' a...@ib-aid.com [firebird-support]
Hello, Azure simply does not deliver what it promises - simple test www.ib-aid.com/dbtest gives results for Azure premium ssd in the lowest 25%, simple CrystalDiskMarks shows awful results too. Your server is yours, but Azure promises Enterprise grade performance, without worries abour RAID, ssd,

Re: [firebird-support] Scaling Firebird - Azure

2019-10-09 Thread 'Alexey Kovyazin (ak)' a...@ib-aid.com [firebird-support]
Hello, In short words, Azure sucks, its so called Premium SSD is worse than the cheapest consumer grade ssd. Try Google Cloud or Amazon, or Hetzner. Regards, Alexey Kovyazin IBSurgeon пн, 7 окт. 2019 г., 0:20 Rune Horneland rune.hornel...@kravia.net [firebird-support] : > > > Hi, > We are

Re: [firebird-support] Re: Does gbak use WireCompression?

2019-09-17 Thread 'Alexey Kovyazin (ak)' a...@ib-aid.com [firebird-support]
Martin, Vlad head read my mind and answered :) Try remote restore through service manager, it is much faster. Regards, Alexey Kovyazin вт, 17 сент. 2019 г., 9:59 hv...@users.sourceforge.net [firebird-support] < firebird-support@yahoogroups.com>: > > > ---In firebird-support@yahoogroups.com,

Re: [firebird-support] gbak of encrypted database

2018-05-01 Thread 'Alexey Kovyazin (ak)' a...@ib-aid.com [firebird-support]
Hello, gbak does not support encryption in the standard Firebird 3.0 distribution. In IBSurgeon's plugin implementation there is a gbak support, with transparent encryption of backups with the same key. https://ib-aid.com/en/firebird-encryption-plugin-framework/ And restored database from the

Re[2]: [firebird-support] How to change cpu utilization in Firebird engine?

2017-01-07 Thread Alexey Kovyazin (ak) a...@ib-aid.com [firebird-support]
Hi, There is no sense to tune or upgrade CPU or other hardware without prior analysis of slowness reasons. In 95% the reason is in non-optimal queries plans or absense of indices. -- Regards, Alexey Kovyazin IBSurgeon суббота, 07 января 2017г., 11:26 +03:00 от trsk...@yahoo.com

[firebird-support] Re: FB Conference 2016

2016-10-07 Thread Alexey Kovyazin (ak) a...@ib-aid.com [firebird-support]
Hi Andre! Thank you! Have a good vacation! We will definetely do more conferences and meet there! -- Regards, Alexey Kovyazin IBSurgeon пятница, 07 октября 2016г., 09:53 +02:00 от André Knappstein andre.knappst...@beta-eigenheim.de : >Hello Alexey, >hello Dmitry, > >I hope the conference

Re: [firebird-support] Slow Firebird performance in Azure with durable data disks (e.g., Premium Storage)

2016-08-30 Thread Alexey Kovyazin (ak) a...@ib-aid.com [firebird-support]
Hi Antti, Try to lock database with nbackup and check the peformance with locked database - in this case all writes will go to delta file sequentially. If your assumption is true and Premium Storage does not work good with random writes, you will see less decrease of performance. Also, there

Re: [firebird-support] Issue with Database Cache Size on FB 3.0

2016-05-31 Thread Alexey Kovyazin (ak) a...@ib-aid.com [firebird-support]
Hi Fabian, Firebird caches only actually used pages. The small cache means that your application touches the small part of the database. -- Regards, Alexey Kovyazin IBSurgeon PS It is difficult and wrong to give you any direct advice without all details in hands - it can lead to worse

[firebird-support] Re[2]: [FB 2.1] Firebird engine seems to slow down on high load without utilizing hardware

2016-04-13 Thread Alexey Kovyazin (ak) a...@ib-aid.com [firebird-support]
Patrick, Definetely you need to compare real life loads. -- Regards, Alexey Kovyazin IBSurgeon среда, 13 апреля 2016г., 04:47 +03:00 от " thetr...@yahoo.com [firebird-support]" < firebird-support@yahoogroups.com> : >  > >Hey Alexey, >thanks you for our input. I think what you say is correct,

[firebird-support] Re[2]: [FB 2.1] Firebird engine seems to slow down on high load without utilizing hardware

2016-04-13 Thread Alexey Kovyazin (ak) a...@ib-aid.com [firebird-support]
Hi, You wrote: >The thing is, sure this numbers look really low. But >the system never uses >it. The monitoring of the >SAN show's that this load's are never used You are confusing the reason and the result. Monitoring shows low numbers because spinning drives cannot provide fast enough random