Re: [firebird-support] Re: Firebird temp files

>>Either some GTT was used or temporary >>blob storage was requested. Why do >>you want it to be prevented? RAM is fast disc is slow and i have plenty of free RAM. Also i have bigger cache then database pages count and this operations can be all done in memory. >>In SS, it will be

Re: [firebird-support] Diagnosing CPU usage

10.05.2018 15:12, Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support] wrote: > We have no way of debugging every single one of the applications being run, > and there is no single obvious operation that could justify this high cpu > usage. > > Is there a way to monitor queries not only

Re: [firebird-support] Trying to use FB3 example to encrypt database

10.05.2018 13:19, OAZEZ Software - José Eduardo joseedua...@oazez.com.br [firebird-support] wrote: > 5) alter database encrypt with "cryptdb.dll"; Name of the plugin is "cryptDb", not "cryptdb.dll". -- WBR, SD.

[firebird-support] Diagnosing CPU usage

Hello I have a situation which is hard to debug. We are running about 50 databases (firebird 3.0.3) on a single server, all of them connected to different applications. CPU usage is normaly low, but sporadically it will peak at 100% and cause problems for all the connections. We have no way

[firebird-support] Re: Firebird temp files

09.05.2018 20:02, liviuslivius wrote: > Ok, i understand temp file caching but why Firebird create this temp > file at all and how to prevent this? Either some GTT was used or temporary blob storage was requested. Why do you want it to be prevented? > And second question, why file handle is

[firebird-support] Trying to use FB3 example to encrypt database

I'm trying to build it with Delphi Tokyo, and when I try to encrypt the database I'm getting the message: - Error loading plugin cryptdb.dll - Module {FIREBIRDDIR}\plugins\cryptdb.dll does not contain plugin cryptdb.dll type 9 My steps: 1) Installed Firebird 3.0.3 (NNF) 2) Rename

Re: [firebird-support] Subscribe and question

On 10-5-2018 12:12, 'Primoz Jenko' primoz.je...@domplan.si [firebird-support] wrote: > > > Hi, Mark, > > thank you very much for detailed questions! > > Answers are: > > -WIN 10 is only on client > > -We have tried both: embeded and locall – nothing was working > > -FB runs as service >

RE: [firebird-support] Subscribe and question

Hello, Karol, thank you very much for your respond! Firebird is installed on different machine with WIN Server OS, only on local machine (client) there is WIN 10, with no FB istalled. On local machine there is only our software that uses FB from server. We can not acces it even with

RE: [firebird-support] Subscribe and question

Ar you sure that your answers are true?You say that win10 is only a clien and then that when you restore to update 1709 you see that fb is listen. I suppose you have Firebird installed on this Win10 machine and it serve client and server in the same time. Is this true or your config os

Re: [firebird-support] Re: Firebird temp files

Yes, you have right  but i really try to avoid RAM disc which consume memory always i prefer if some resource free memory it is available to be consumed by any process.  Do you know why this file is created at all and especially why its handle is still active in firebird process few days?

RE: [firebird-support] Subscribe and question

Hi, thank you! We will do it. Best wishes, Primoz -Original Message- From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Thursday, May 10, 2018 12:17 PM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] Subscribe and question

RE: [firebird-support] Subscribe and question

Hi, Mark, thank you very much for detailed questions! Answers are: - WIN 10 is only on client - We have tried both: embeded and locall – nothing was working - FB runs as service - We wil try to run it as application - FB process is working, we

Re: [firebird-support] Re: Firebird temp files

10.05.2018 8:47, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: > Thank you for the suggestion. We will consider RAM disc uses but first we > must be sure how > big it should be to catch all cases. It, actually, doesn't matter. If you configure several temporary

[firebird-support] Hallo world

He, now I enter in the Firebird group. Good morning to all. Antonio BIANCA --- Questa e-mail è stata controllata per individuare virus con Avast antivirus. https://www.avast.com/antivirus

RE: [firebird-support] Subscribe and question

Precisely that, thanks Regards Bogdan. From: firebird-support@yahoogroups.com Sent: Thursday, May 10, 2018 9:52 AM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] Subscribe and question On 10-5-2018 09:27,

Re: [firebird-support] Subscribe and question

On 10-5-2018 09:27, bog...@mordicom.si [firebird-support] wrote: > > > We've had Firebird 2.0 database in dialect 1. > > When we installed 2.5 64 server, connection was not possible. > > If my memory serves me well  Ah, well as far as I know the dialect shouldn't make a difference there. I

Re: [firebird-support] Subscribe and question

On 9-5-2018 16:48, 'Primoz Jenko' primoz.je...@domplan.si [firebird-support] wrote: > I would have a question why, after automatic upate of WIN 10, update > package 1803,FB  2.0.5.13206 (our software using those two) generates an > error 335544721, Failed to established a connection? > > We

RE: [firebird-support] Subscribe and question

We've had Firebird 2.0 database in dialect 1. When we installed 2.5 64 server, connection was not possible. If my memory serves me well  Bogdan From: firebird-support@yahoogroups.com Sent: Thursday, May 10, 2018 9:09 AM To:

Re: [firebird-support] Subscribe and question

On 10-5-2018 08:01, bog...@mordicom.si [firebird-support] wrote: > What is the dialect of the database ? I don't see how the dialect would be relevant for this problem. Could you explain what problem you where thinking of? Mark -- Mark Rotteveel

[firebird-support] Monitoring tables indexes

Hi, can i ask why monitoring tables have not any indexes? Any left join go into natural scan as we have not hash/merge for outer join (core-4823). Regards,Karol Bieniaszewski

RE: [firebird-support] Re: Firebird temp files

Hi, Thank you for the suggestion. We will consider RAM disc uses but first we must be sure how big it should be to catch all cases. It should be docummented how temp tables work (maybe it is somwhere?) with temp files. Regards,Karol Bieniaszewski null

RE: [firebird-support] Subscribe and question

What is the dialect of the database ? Regards Bogdan From: firebird-support@yahoogroups.com Sent: Wednesday, May 9, 2018 4:48 PM To: firebird-support@yahoogroups.com Subject: [firebird-support] Subscribe and question Hello, I would have a