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

Hi Karol, we have chosen the following solution to avoid temp disk writes: * Firebird 2.5.8 classic default configuration (with 2 changes see below) * 456 databases (~379 GB) * average ~4000 fb_inet_server processes * 10 GB ramdisk (/ramdisk/fb_temp) for external files and for

Re: [firebird-support] execute block where External datasource is localhost :p

hmmm that make sense . thanks for your help, really appreciate .

[firebird-support] Subscribe and question

Hello, 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 have tried a lot of posibilities, but no effect. We have upgrade to FB 3.0.3 and problem

[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] Re: Firebird temp files

Ok, i understand temp file caching but why Firebird create this temp file at all and how to prevent this? And second question, why file handle is still active? Is this file for particular temporary table or it is a buffor for all temporary tables? Regards,Karol Bieniaszewski null

Re: [firebird-support] Re: Limit of the page cache buffer in Firebird 2.5?

Thank you very much! On Wednesday, May 9, 2018, 2:57:26 AM CDT, Dmitry Yemanov dim...@users.sourceforge.net [firebird-support] wrote:   08.05.2018 20:50, Javier Cintron wrote: > Firebird ver 2.5.7.27050 64 bits > Superserver > Windows Server

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

>> No, caching is left up to OS. i do not understand above. I have dissabled os caching in firebird.conf. Also file is created by Firebird not OS. Can you explain this more? Regards,Karol Bieniaszewski null

[firebird-support] Re: Firebird temp files

09.05.2018 17:15, liviuslivius wrote: > >> No, caching is left up to OS. > > i do not understand above. I have dissabled os caching in firebird.conf. > Also file is created by Firebird not OS. Can you explain this more? You've disabled file-level caching for the database file, but this

[firebird-support] Re: Firebird temp files

09.05.2018 11:41, liviuslivius wrote: > Is there particular settings to go always into RAM or some buffer > settings which i can increase to avoid going to disc? No, caching is left up to OS. > I have now > TempCacheLimit = 800M It doesn't affect GTTs. Dmitry

Re: [firebird-support] execute block where External datasource is localhost :p

On 2018-05-08 18:45, Issam Boughanmi amigof...@gmail.com [firebird-support] wrote: > i am writing a little .net application that connect to a remote > database server hosted on internet to make a sort of replication . > > so the database source live in my local firebird server the > destination

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

Thank you for the info Is there particular settings to go always into RAM or some buffer settings which i can increase to avoid going to disc? I have nowTempCacheLimit = 800MMentioned file is 29MB in size and dated 2 days old and its handle is still in use by Firebird process Regards,Karol

[firebird-support] Re: Limit of the page cache buffer in Firebird 2.5?

08.05.2018 20:50, Javier Cintron wrote: > Firebird ver 2.5.7.27050 64 bits > Superserver > Windows Server 2012R2 > > This link > says that the maximum size of the page cache buffer is  131,072 pages. > > This limit also applies to Firebird 2.5 x64 superserver in Windows? 131,072 pages is the

[firebird-support] Re: Firebird temp files

09.05.2018 10:25, liviuslivius wrote: > > what is the purpose of temp file named e.g. > fb_table_yfz4x5? Storage for global temporary tables. Dmitry

[firebird-support] Firebird temp files

Hi, what is the purpose of temp file named e.g.fb_table_yfz4x5?I use FB3 regards,Karol Bieniaszewski

RE: [firebird-support] execute block where External datasource is localhost :p

FOR execute statement VSQL ON EXTERNAL DATA SOURCE '127.0.0..1:C:\BDD\D2018.gdb' AS USER 'sysdba' PASSWORD 'masterkey' INTO :panum, :nom, :prenom, :dna, :DATEMODIF DO 127.0.0..1 To dots maybe ? Regards Bogdan From: firebird-support@yahoogroups.com