Re: [firebird-support] PASCAL UDR - stored procedure BLOB param and return

2018-05-22 Thread 'livius' liviusliv...@poczta.onet.pl [firebird-support]
Anyone can point me in some direction? regards, Karol Bieniaszewski From: 'livius' liviusliv...@poczta.onet.pl [firebird-support] Sent: Monday, May 21, 2018 9:35 PM To: firebird-support@yahoogroups.com Subject: [firebird-support] PASCAL UDR - stored procedure BLOB param and return Hi, i c

Re: [firebird-support] Choosing best server / processor for Firebird 3.03 64 bits database on Windows server 2016 64 bits

2018-05-22 Thread 'livius' liviusliv...@poczta.onet.pl [firebird-support]
Hi, as always RAM is crucial for DB, but with such size of DB you can only benefit “a little” I do not know the reall usage scenario – what data is used and how many data are “analyzed” by normal user. Does database contain historical data not comonly accessed or user “scan” whole db every day?

[firebird-support] Upgrade from superclassic to superserver

2018-05-22 Thread kragh.tho...@yahoo.com [firebird-support]
Hey I am in the process of upgrading our Firebird database from 2.5.7 to 3.0.3. While making the upgrade, I want to switch from SuperClassic to SuperServer in order to gain better scalability. However configuring SuperServer i new to me. Background information: The database server is a 16 cor

Re: [firebird-support] Upgrade from superclassic to superserver

2018-05-22 Thread 'livius' liviusliv...@poczta.onet.pl [firebird-support]
Hi, few things: 1. instead FB3.0.3 use recent snapshot. It contain many fixes. 2. look at settings about buffers in your DB itself if it utilize config then increase DefaultDbCachePages. Currently you set it to only to 8GB – but db size is much bigger. Is this server to serve only this database

[firebird-support] Re: Upgrade from superclassic to superserver

2018-05-22 Thread blackfalconsoftw...@outlook.com [firebird-support]
Thomas... You may want to consider purchasing Carlos' e-book on Firebird Migration at the following link... https://www.firebirdnews.org/migration-guide-to-firebird-3/ https://www.firebirdnews.org/migration-guide-to-firebird-3/ It is very well written and has a lot of information rega

RE: [firebird-support] Firebird using all available memory

2018-05-22 Thread 'Thomas Kragh-Pedersen (TKG)' t...@kmd.dk [firebird-support]
Hey Fabiano Perhaps DefaultDbCachePages is overwritten by database header information. Gstat -h will tell you that. Look for “Page buffers” From: firebird-support@yahoogroups.com Sent: 18. maj 2018 16:12 To: firebird-support@yahoogroups.com Subject: [firebird-support] Firebird using all availab