Re: [Firebird-docs] Adding new doc "Firebird UDRs in Pascal"

2023-09-20 Thread Alexey Kovyazin (ak) via Firebird-docs
Hello, Lets put there IDPL. Regards, Alexey Kovyazin Денис Симонов via Firebird-docs : > I don't mind. This article was originally created for general access, > although I did not think about the license, but if necessary, I can add so > that there is no contradiction > > -- > Regards, >

Re: [Firebird-docs] Outdated documents

2021-07-05 Thread Alexey Kovyazin (ak)
Hello Mark, May be we can map page of multi page document to the link of single page document with anchor? Regards, Alexey Kovyazin пн, 5 июл. 2021 г., 22:09 Mark Rotteveel : > On 05-07-2021 20:04, Alexey Kovyazin wrote: > > I just found that we have a hidden nest of old versions of many

Re: [Firebird-docs] Firebird 3.0 Language Reference

2021-02-23 Thread Alexey Kovyazin (ak)
Hello, I took a quick look and did not see any noticeable problem. Regards, Alexey вт, 23 февр. 2021 г., 19:27 Mark Rotteveel : > I'm going to publish the links tomorrow. > > Mark > > On 20-02-2021 17:02, Mark Rotteveel wrote: > > I have finished up the first version of the Firebird 3.0

Re: [Firebird-docs] gstat OST - OIT and Sweep

2020-07-31 Thread Alexey Kovyazin (ak)
Hello Martin, I spoke with Vlad about section devoted to garbage, and we agreed it is difficult. I plan to rewrite it with pictures explaining records versions, garbage and sweep, but it really needs courage :) I suggest to let ost-oit phrases as is. Regards, Alexey Kovyazin IBSurgeon пт,

Re: [Firebird-docs] Translation of Russian Firebird 3.0 Language Reference

2020-07-30 Thread Alexey Kovyazin (ak)
Hello, We did survey in Telegram channel, and idea was to skip 3.0 and do the translation of LR4.0... Regards, Alexey Kovyazin IBSurgeon чт, 30 июл. 2020 г., 12:55 Mark Rotteveel : > On 2020-07-30 09:44, Köditz wrote: > > Hello everybody, > > > > I was asked whether it would make sense to

Re: [Firebird-docs] Firebird File and Metadata Security migrated

2020-07-01 Thread Alexey Kovyazin (ak)
Hello, I support the idea of the single Page list/index for all docs. I suggest that we should create such page, and then ask people about their opinion (it will also increase awareness of documentation). Regards, Alexey Kovyazin ср, 1 июл. 2020 г., 16:31 Paul Vinkenoog : > Mark Rotteveel

Re: [Firebird-docs] Conversion of fbutil-*

2020-06-15 Thread Alexey Kovyazin (ak)
Hello Mark, I think it is necesary to keep the current structure, and unite them only virtually, since "command line tools" is a weak basis for grouping such different tools. Theoretically, they should be parts of Firebird Admin Guide, but now they are just pieces. Another question - do you plan

Re: [Firebird-docs] The single Page for the documentation outline

2020-05-27 Thread Alexey Kovyazin (ak)
Hello Mark, Like that Page but with high level table of contents for each document. Regards, Alexey Kovyazin ср, 27 мая 2020 г., 14:25 Mark Rotteveel : > On 2020-05-27 09:43, Alexey Kovyazin (ak) wrote: > > Hello All, > > > > As you know, Firebird documentation contai

[Firebird-docs] The single Page for the documentation outline

2020-05-27 Thread Alexey Kovyazin (ak)
Hello All, As you know, Firebird documentation contains a set of documents, and they are grouped in several pages, by the topic or type of documents, like Release Notes, etc. Should we consider build the overall list of the docs and put to the Documentation starting Page? It would be like a big

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