Re: [firebird-support] FB3 Embedded Firedac Error

2019-09-03 Thread Elton Fadel galdari...@yahoo.com.br [firebird-support]
>This is quite interesting, if the service is stopped and no Firebird server >running, then how can you access the database, it might be that you >already >correctly setup the embedded server and the application load the embedded >server IB-Expert and Delphi still running with all

Re: [firebird-support] CpuAffinityMask on firebird 3.X and firebird memory leakage

2019-09-03 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
03.09.2019 13:53, 'Check_Mail' check_m...@satron.de [firebird-support] wrote: > but the UDFs I haven’t change in. So a leak in them (if any) has no chance to be fixed. > How can I delimit this leak? Can I debug > the memory? Developers version of Firebird writes memory leaks into file on

Re: [firebird-support] FB3 Embedded Firedac Error

2019-09-03 Thread Iwan Cahyadi Sugeng iwan.c.sug...@gmail.com [firebird-support]
See my replies below On Tue, Sep 3, 2019 at 1:13 PM Elton Fadel galdari...@yahoo.com.br [firebird-support] wrote: > > > > Thanks, Mark! *It worked!* > > I also notice something very interesting during my tests: > > 1. No matter if you use Firebird if a Service or Application, even without >

AW: [firebird-support] CpuAffinityMask on firebird 3.X and firebird memory leakage

2019-09-03 Thread 'Check_Mail' check_m...@satron.de [firebird-support]
Hello Dmitry, but the UDFs I haven’t change in. How can I delimit this leak? Can I debug the memory? -Ursprüngliche Nachricht- Von: firebird-support@yahoogroups.com Gesendet: Dienstag, 3. September 2019 13:17 An: firebird-support@yahoogroups.com Betreff: Re: [firebird-support]

Re: [firebird-support] CpuAffinityMask on firebird 3.X and firebird memory leakage

2019-09-03 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
03.09.2019 13:12, 'Check_Mail' check_m...@satron.de [firebird-support] wrote: > How can I understand this gap? The biggest probability is a memory leak in your UDFs. -- WBR, SD.

AW: [firebird-support] CpuAffinityMask on firebird 3.X and firebird memory leakage

2019-09-03 Thread 'Check_Mail' check_m...@satron.de [firebird-support]
Hello Dimitry, Thank you. I have checked the monitoring table, the sum of active memory usage is 160MB, the max usage around 290MB. But the firebird process takes up ca. 730MB. How can I understand this gap? Also the memory usage of the firebird.exe increases over the time till the max of 32Bit

Re: [firebird-support] CpuAffinityMask on firebird 3.X and firebird memory leakage

2019-09-03 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
03.09.2019 12:10, 'Check_Mail' check_m...@satron.de [firebird-support] wrote: > if we use the default firebird.conf with #CpuAffinityMask = 0, does firebird > use all > cpus/cores? Or should I set it to 15 for 4 cores? I have found some > information for the > 2.5 only. For Firbird 3 CPU

[firebird-support] CpuAffinityMask on firebird 3.X and firebird memory leakage

2019-09-03 Thread 'Check_Mail' check_m...@satron.de [firebird-support]
Hello, if we use the default firebird.conf with #CpuAffinityMask = 0, does firebird use all cpus/cores? Or should I set it to 15 for 4 cores? I have found some information for the 2.5 only. We have some memory-problems on firebird 3.0.1 32 Bit Superserver on server 2008 32 Bit, the one

Re: [firebird-support] Performance of deleting records based on another table

2019-09-03 Thread Joost van der Sluis jo...@cnoc.nl [firebird-support]
On 8/28/19 6:47 AM, Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support] wrote: > Den 2019-08-17 kl. 12:51, skrev Joost van der Sluis jo...@cnoc.nl > [firebird-support]: > > > > Hi all, > > > > I finally realized today that I do not know how to properly remove > > records based

Re: [firebird-support] FB3 Embedded Firedac Error

2019-09-03 Thread Elton Fadel galdari...@yahoo.com.br [firebird-support]
Thanks, Mark! It worked! I also notice something very interesting during my tests: 1. No matter if you use Firebird if a Service or Application, even without installing the guardian:Stop the Service or do Shutdown of the Application on tray icon has zero effect! It stays working normally on