[firebird-support] Re: FB 3.0, got problem when add field to Table with existing data

02.06.2016 07:42, trsk...@yahoo.com wrote: > > I have a table with existing data & got a problem to add field that must > have a value -> alter table Tbl1 add Fld1 int not null. What value must it have? Add a default clause to this statement. Or add the field as nullable, populate with data and

[firebird-support] FB 3.0, got problem when add field to Table with existing data

Hi guys, I have a table with existing data & got a problem to add field that must have a value -> alter table Tbl1 add Fld1 int not null. If table doesn't have data, it is OK, but Firebird refused if table already have data. Any suggestion how to solve this problem? Thanks & regards, Anto

[firebird-support] Re: Max RAM for Database Cache in SS FB 3.0 64bit is to small?

02.06.2016 03:44, trsk...@yahoo.com wrote: > > Am I correct that maximum allowed RAM for database cache on SS FB 3.0 in > Win64 is only 2 GB? Calculated from max DefaultDbCachePages (131072) x > max Page Size (16384) = 2 GB. Correct for 32-bit builds. 64-bit builds don't have such a limit. >

[firebird-support] Max RAM for Database Cache in SS FB 3.0 64bit is to small?

Hi guys, Am I correct that maximum allowed RAM for database cache on SS FB 3.0 in Win64 is only 2 GB? Calculated from max DefaultDbCachePages (131072) x max Page Size (16384) = 2 GB. Setting DefaultDbCachePages more than allowed caused a crashed. If this true, how to optimaze free RAM for

Re: [firebird-support] Re: Issue with Database Cache Size on FB 3.0

Hi Robert Here is the link to both files as the yahoo group may not allow me to attach the files http://document.nucleuscrm.com.au:7770/pdfs/TMPFiles/TaskManager_Performance_ALL_RAM_Consumed.jpg

Re: [firebird-support] Re: Issue with Database Cache Size on FB 3.0

Hi Fabian Can't see your screen shot but FB usage at 2GB sounds like the limit for a 32Bit app. Have you installed the 32Bit version of FB accidentally? Thanks Rob On 2/06/2016 11:12 a.m., fabia...@itbizolutions.com.au [firebird-support] wrote: Dmitry Something funny is going on

Re: [firebird-support] Re: Issue with Database Cache Size on FB 3.0

Dmitry Something funny is going on regarding the memory consumption, I have attached screenshots showing the memory counters. If you look at the process itself (file TaskManager_Process_Firebird_Only_Consumed_2GB.jpg), it only consumed 2 GB. If you look at Windows Task Manager (file

Re: [firebird-support] Stored Procedures Execution Plan

Hi, you must convert any procedure - for which you need plan - to execute block format if you are interested in plan for proc 1 then you need proc 1 execte block if this proc1 use proc2 you need to make proc2 as execute block.. regards, Karol Bieniaszewski From:

[firebird-support] Detailed information in regards to Trusted Authentication

Hi, I am testing Firebird 3 and one of the tests happens to be finding out if it supports Active Directory. I am assuming that trusted user authentication passes the user identity as per the local machine to the server. The question I have is how you would setup a linux box (already part

Re: [firebird-support] Re: Firebird 3 on Kubuntu 16.04

Thanks, I removed Firebird and tried the downloads from Sourceforge, all is working fine now. From: firebird-support@yahoogroups.com on behalf of peshk...@mail.ru [firebird-support] Sent:

Re: [firebird-support] Re: Issue with Database Cache Size on FB 3.0

Hi Dmitry I am progressing with solving this one, the first issue was related with a config variable reserving most of the ram upfront, hence there was no ram available for the DB cache. The second issue was misinterpreting what the following meant: # File system cache size # Note that the

Re: [firebird-support] Re: Issue with Database Cache Size on FB 3.0

Vlad Thank you, english is not my first language, I interpreted the sentence as "go calculate the total amount of ram, then set the value as a number within such percentage of your ram...", but thanks for the clarification. Perhaps to avoid other users making the same mistake each configurable

[firebird-support] Looking for example how to use FBTraceManager api in java.

Hi, I'm looking for some example how to use TraceAPI provided in Jaybird. -- Doychin Bondzhev dSoft-Bulgaria Ltd. PowerPro - billing & provisioning solution for Service providers PowerStor - Warehouse & POS http://www.dsoft-bg.com/ Mobile: +359888243116 [Non-text portions of this message have

Re: Re: [firebird-support] Stored Procedures Execution Plan

Hi, One problem with this approach (changing SP's to execute block) is that you still have the possibility of doesn't getting called SP plans (SP's called by the SP which you are converting to an execute block). Att.João Paulo DE: "liviuslivius liviusliv...@poczta.onet.pl

Re: [firebird-support] Stored Procedures Execution Plan

Hi. I've been trying to skim over some possibilities to investigate possible limitations. Here it follow my results and test cases: - If you call Stored Procedures (SP's) with EXECUTE PROCEDURE statements, plans are not available;- If you call SP's via SELECT FROM, you got expected statement

Re: [firebird-support] Issue with Database Cache Size on FB 3.0

Dimitry That is my concern, on FB 2.5 I was able to see the memory allocated as soon as the first connection is granted to the DB, but on FB 3 I am not seeing almost any memory been allocated what makes me believe that something is not right. However as more users connect and use the DB, the

Re: [firebird-support] Issue with Database Cache Size on FB 3.0

Hi Alexey Thank you, I've noticed as the App was being used the DB cache was eating more memory, so I guess the config may be ok, it is a matter of loading more users online and check the memory Cheers Fabian - Original Message - From: Alexey Kovyazin (ak) a...@ib-aid.com

[firebird-support] Re: Issue with Database Cache Size on FB 3.0

---In firebird-support@yahoogroups.com, wrote : ... > The setting we are playing with are: > > On firebird.conf > > FileSystemCacheThreshold = 0 > FileSystemCacheSize = 17179869184 (this is 16 GB - the server has 32 GB > ram.) Does you ever read comments describing this

Re: Re: [firebird-support] Stored Procedures Execution Plan

Hi,   yes but this was "wrong" Consider this: inside procedure you have 5 different statements and you run query and only two of them are reached - do you really need to see all 5?   Ok - now you got only "natural" word for procedure - i do not know if this is better now.. But if you need plan

[firebird-support] Re: Firebird 3 on Kubuntu 16.04

Have you tried binaries from SF?