[firebird-support] Re: Slow Commit

2012-05-04 Thread ma_golyo
Hi! Maybe this is your case : Forced Writes Performance impact on #Ubuntu with ext4 no barrier http://www.firebirdnews.org/?p=6421 --- In firebird-support@yahoogroups.com, aalliana aalliana@... wrote: Hello, I'm trying to upgrade a box running ubuntu + firebird that has been running

Re: [firebird-support] Charindex in firebird

2012-05-04 Thread Thomas Steinmaurer
Could you please help me how to use charindex in firebird as this function is not available in firebird compare to SQL * What is this function supposed to do? Finding the position of a char in a string or the ASCII code of a char ... * What Firebird version do you use? -- With regards,

[firebird-support] Re: Where is firebird.log located

2012-05-04 Thread Office Manager
Mine is here: D:\Apps\Firebird\Firebird_2_5\firebird.log

Re: [firebird-support] Where is firebird.log located

2012-05-04 Thread Mark Rotteveel
On Fri, 04 May 2012 03:04:16 -, daniel.ach@gmail.com wrote: Hi all! As far as I understand there is a firebird.log-file on client and on server side. I have firebird 1.5.6 installed on Windows 7 and a Windows 2008 Server and I'm looking for the server side Firebird.log-file but

[firebird-support] Isql transaction question

2012-05-04 Thread Rick Debay
Is a new transaction started after a commit command in an isql script? Disclaimer: This message (including attachments) is confidential and may be privileged. If you have received it by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized

[firebird-support] Unique foreign key for child tables

2012-05-04 Thread Rick Debay
I have a parent table with multiple child tables. Each child row has a foreign key that points to one row in the parent. Each parent row must have a child row pointing to it. Each parent row can have only child from any of the child tables pointing to it. The child is created before the parent. A

RE: [firebird-support] Unique foreign key for child tables

2012-05-04 Thread Leyne, Sean
I have a parent table with multiple child tables. Each child row has a foreign key that points to one row in the parent. Each parent row must have a child row pointing to it. Each parent row can have only child from any of the child tables pointing to it. The child is created before the

Re: [firebird-support] Isql transaction question

2012-05-04 Thread Thomas Steinmaurer
Is a new transaction started after a commit command in an isql script? No, according to the output of a trace session. A transaction gets automatically started once you execute a new statement. -- With regards, Thomas Steinmaurer (^TS^) Firebird Technology Evangelist http://www.upscene.com/

RE: [firebird-support] A different solution

2012-05-04 Thread Leyne, Sean
All I really need to do is have all of the queries (there's a dozen or so) update when the book is opened, and then run some code on the data when the updates are complete. You are talking about building a Excel macro which automatically runs based on the Workbook_Open event. That macro

[firebird-support] Re: Slow Commit

2012-05-04 Thread aalliana
Beautiful! Thanks for the tip. After disabling barriers commits that were taking 4 s take virtually no time at all. I'm wondering what would the consequences would be if I keep the barriers disabled on a production environment. Thanks a lot. --- In firebird-support@yahoogroups.com, ma_golyo