Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2

2014-02-18 Thread Carlos H. Cantu

Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2

2014-02-18 Thread Alexey Kovyazin
Hi, I suppose we all have our opinions. This is not an opinion, this is statement, confirmed by our 12 years experience with Firebird and 5 years with Win 2008. Your problem with Win2008 is lack of knowledge, that's all, sorry for the truth. And I'm not going to offer such technical

RE: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2

2014-02-18 Thread Marius Labuschagne
Hi, I suppose we all have our opinions. This is not an opinion, this is statement, confirmed by our 12 years experience with Firebird and 5 years with Win 2008. Your problem with Win2008 is lack of knowledge, that's all, sorry for the truth. And I'm not going to offer such technical support

Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2

2014-02-18 Thread Alexey Kovyazin
Hi Marius, Sorry, I don't want to be rude. I just want to point that there is no problem with Windows 2008 R2, and a bit tired with all the same questions (with the same answers). Our largest customers databases are on Win2008R2, and it works just fine - 500+ users and 150Gb, 440Gb with 50

[firebird-support] Problems inserting a new record on not matched condition

2014-02-18 Thread jim.rhema316
Good day. I am trying to insert a record into a file when I get an unmatched condition on the merge but I get an error saying it can't find the column for the insert. Here is the code: merge into tableA e using tableB s on (e.field1 = s.field2) when not matched then insert

Re: [firebird-support] Problems inserting a new record on not matched condition

2014-02-18 Thread Saunders, Rich
On 2014-02-18 11:52, jim.rhema...@gmail.com wrote: merge into tableA e using tableB s on (e.field1 = s.field2) when not matched then insert (ACTION,ITEMID,TITLE,SITEID,CURRENCY,STARTPRICE,BUYITNOWPRICE,QUANTITY,RELATIONSHIP,RELATIONSHIPDETAILS,CUSTOMLABEL,MATCHED,VENDOR) values

RE: [firebird-support] Problems inserting a new record on not matched condition

2014-02-18 Thread Leyne, Sean
I am trying to insert a record into a file when I get an unmatched condition on the merge but I get an error saying it can't find the column for the insert. Here is the code: merge into tableA e using tableB s on (e.field1 = s.field2) when not matched then insert

[firebird-support] Required information for Firebird database performance optimization

2014-02-18 Thread Alexey Kovyazin
Hi All, I am a bit tired of repeated topics regarding database performance, so I decided to publish short version of our performance questionnaire: http://ib-aid.com/articles/item157 I suggest to always ask people who come here with Firebird performance problems to answer these questions and

Re: [firebird-support] Required information for Firebird database performance optimization

2014-02-18 Thread Dmitry Kuzmenko
Hello, Alexey! Tuesday, February 18, 2014, 10:10:09 PM, you wrote: AK I am a bit tired of repeated topics regarding database performance, so I AK decided to publish short version of our performance questionnaire: AK http://ib-aid.com/articles/item157 These questios are also useful becase even

Re: [firebird-support] Required information for Firebird database performance optimization

2014-02-18 Thread Hannes Streicher
Guten Tag Alexey Kovyazin, nice Questionaire , i would suggest to add 1 more point if it has a Raid then the size of the Stripe Set The Stripe Set ist the amount of data a raid moves to / from the diskarray for every read/write. Example: a Raid 5 with 3 Disks and a Stripset of 128 KB means

RE: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2

2014-02-18 Thread Bogdan
I second this answer. Regards, Bogdan MordiCom d.o.o. i...@mordicom.si +386 (05) 33 00 360 From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Alexey Kovyazin Sent: Tuesday, February 18, 2014 3:01 PM To: firebird-support@yahoogroups.com

Re: [firebird-support] Required information for Firebird database performance optimization

2014-02-18 Thread Alexey Kovyazin
Hi Hannes, Good point, thank you - I added it. Regards, Alexey Kovyazin Guten Tag Alexey Kovyazin, nice Questionaire , i would suggest to add 1 more point if it has a Raid then the size of the Stripe Set The Stripe Set ist the amount of data a raid moves to / from the diskarray for every

Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2

2014-02-18 Thread Zsazsi
Hi folks, Alexey might be referring to us as we also had some performance issues under Win2008R2 and FB 252 SS, but we started a different thread, so I might as well be wrong. Anyway we are still in the process of evaluating the impact of our resolving actions on performance. The operator