Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
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 for free in this support list, sorry. Try other Firebird service providers: http://www.firebirdsql.org/en/professional-support/ may be they have free time. Regards, Alexey Kovyazin IBSurgeon
RE: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
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 for free in this support list, sorry. Try other Firebird service providers: http://www.firebirdsql.org/en/professional-support/ may be they have free time. Regards, Alexey Kovyazin IBSurgeon [Marius Labuschagne] What you doing in this forum Alexey? As far as I am aware this is a support forum, am I wrong? You promoting your business over here with all your years of experience? (Or at least you must be thinking that 12 is a very high number) Lets leave it at that, I would not dare ask you for any support anyway. Regards Marius
Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
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 users, etc, etc. And, btw, 440Gb is running at the server in Port Elizabeth. Regarding promotion of our business - there are very few professional service providers listed on the Firebirdsql.org, and they are also Firebird sponsors. Without our sponsorship Firebird would not exists and all users would sit with InterBase 6.0, as it was released by Borland in 2000. Regards, Alexey Kovyazin IBSurgeon 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 for free in this support list, sorry. Try other Firebird service providers: http://www.firebirdsql.org/en/professional-support/ may be they have free time. Regards, Alexey Kovyazin IBSurgeon */[Marius Labuschagne] /* */What you doing in this forum Alexey? As far as I am aware this is a support forum, am I wrong? You promoting your business over here with all your years of experience? (Or at least you must be thinking that 12 is a very high number)/* */Lets leave it at that, I would not dare ask you for any support anyway./* *//* */Regards/* */Marius/*
[firebird-support] Problems inserting a new record on not matched condition
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
(ACTION,ITEMID,TITLE,SITEID,CURRENCY,STARTPRICE,BUYITNOWPRICE,QUANTITY,RELATIONSHIP,RELATIONSHIPDETAILS,CUSTOMLABEL,MATCHED,VENDOR)
values ('End',e.ITEMID,
e.TITLE,e.SITEID,e.CURRENCY,e.STARTPRICE,e.BUYITNOWPRICE,e.QUANTITY,e.RELATIONSHIP,e.RELATIONSHIPDETAILS,e.CUSTOMLABEL,'N','Sullivans');
What I am trying to accomplish is if there isn't a match I need to insert a
record into tableA because tableA will be an input table into a subsequent
process and the data I need is only on tableA.
Using Firebird 2.5
Any help/direction/ would be greatly appreciated!!
Thank you.
Jim
Re: [firebird-support] Problems inserting a new record on not matched condition
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 ('End',e.ITEMID,
e.TITLE,e.SITEID,e.CURRENCY,e.STARTPRICE,e.BUYITNOWPRICE,e.QUANTITY,e.RELATIONSHIP,e.RELATIONSHIPDETAILS,e.CUSTOMLABEL,'N','Sullivans');
What I am trying to accomplish is if there isn't a match I need to insert a
record into tableA because tableA will be an input table into a subsequent
process and the data I need is only on tableA.
Since it looks to me like you are inserting into tableA with records
from tableB, shouldn't the VALUES() listed be from tableB?
Cheers!
Rich Saunders
[Non-text portions of this message have been removed]
RE: [firebird-support] Problems inserting a new record on not matched condition
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
(ACTION,ITEMID,TITLE,SITEID,CURRENCY,STARTPRICE,BUYITNOWPRICE,QUANTITY,RELATIONSHIP,RELATIONSHIPDETAILS,CUSTOMLABEL,MATCHED,VENDOR)
values ('End',e.ITEMID,
e.TITLE,e.SITEID,e.CURRENCY,e.STARTPRICE,e.BUYITNOWPRICE,e.QUANTITY,e.RELATIONSHIP,e.RELATIONSHIPDETAILS,e.CUSTOMLABEL,'N','Sullivans');
What I am trying to accomplish is if there isn't a match I need to insert a
record into tableA because tableA will be an input table into a subsequent
process and the data I need is only on tableA.
Using Firebird 2.5
Any help/direction/ would be greatly appreciated!!
SL It appears that you have your table aliases backwards… you should be using
“s.” not “e.” in:
'End',e.ITEMID,e.TITLE…
SL Why are you using MERGE if you don’t have a WHEN MATCHED THEN clause?
SL It seems that you are really looking to:
INSERT INTO TableA (
ACTION,ITEMID,TITLE,SITEID,CURRENCY,STARTPRICE,BUYITNOWPRICE,QUANTITY,RELATIONSHIP,RELATIONSHIPDETAILS,CUSTOMLABEL,MATCHED,VENDOR
)
SELECT
'End',s.ITEMID,
s.TITLE,s.SITEID,s.CURRENCY,s.STARTPRICE,s.BUYITNOWPRICE,s.QUANTITY,s.RELATIONSHIP,s.RELATIONSHIPDETAILS,s.CUSTOMLABEL,'N','Sullivans'
FROM tableB s
WHERE
NOT EXISTS (
SELECT 1
FROM TableA e
WHERE e.field1 = s.field2
)
[firebird-support] Required information for Firebird database performance optimization
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 send answers to the list, in order to facilitate performance problems resolution. Regards, Alexey Kovyazin IBSurgeon
Re: [firebird-support] Required information for Firebird database performance optimization
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 just reading them can give an idea where the problem is or what to check in the system. For examle, we ask Is OS running as Virtual Machine instance? because, sure, any RDBMS under virtial machine will work slower than on plain hardware. :-) Of course, not that simple, but ... -- Dmitry Kuzmenko, www.ib-aid.com
Re: [firebird-support] Required information for Firebird database performance optimization
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 that each Read / Write will move 192 KB now add a Database Page Size of 4 KB (Worst Case) then every database page read or written will instead move 192 Kb or a 48 fold overhead 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 send answers to the list, in order to facilitate performance problems resolution. Regards, Alexey Kovyazin IBSurgeon ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo Groups Links -- Mit freundlichen Grüssen Hannes Streichermailto:hstreic...@gmx.de
RE: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
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 Subject: Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2 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 users, etc, etc. And, btw, 440Gb is running at the server in Port Elizabeth. Regarding promotion of our business - there are very few professional service providers listed on the Firebirdsql.org, and they are also Firebird sponsors. Without our sponsorship Firebird would not exists and all users would sit with InterBase 6.0, as it was released by Borland in 2000. Regards, Alexey Kovyazin IBSurgeon 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 for free in this support list, sorry. Try other Firebird service providers: http://www.firebirdsql.org/en/professional-support/ may be they have free time. Regards, Alexey Kovyazin IBSurgeon [Marius Labuschagne] What you doing in this forum Alexey? As far as I am aware this is a support forum, am I wrong? You promoting your business over here with all your years of experience? (Or at least you must be thinking that 12 is a very high number) Lets leave it at that, I would not dare ask you for any support anyway. Regards Marius --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com
Re: [firebird-support] Required information for Firebird database performance optimization
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 read/write. Example: a Raid 5 with 3 Disks and a Stripset of 128 KB means that each Read / Write will move 192 KB now add a Database Page Size of 4 KB (Worst Case) then every database page read or written will instead move 192 Kb or a 48 fold overhead
Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
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 company rebuilt the server from scratch and we have also changed the application logic a bit, but nothing really changed seriously on either side. We aimed to satisfy the needs and satisfaction of the client and therefore we do not want to change or have any impact on the system that might alter the performance negatively yet. We try to suspend this status quo for some time. More to come on the issue and hopefully the cause and resolution, I ask for Your patience. Regarding Alexey's support. I personally asked for Alexey's help and although we have not got into deep system analysis I must say that during the negotiating process Alexey's attitude was way superior, he was fast at reply, helpful and professional. I am sure we will be happy collaborating on other issues in the future. Regards Zsolt *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 *Subject:* Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2 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 users, etc, etc. And, btw, 440Gb is running at the server in Port Elizabeth. Regarding promotion of our business - there are very few professional service providers listed on the Firebirdsql.org, and they are also Firebird sponsors. Without our sponsorship Firebird would not exists and all users would sit with InterBase 6.0, as it was released by Borland in 2000. Regards, Alexey Kovyazin IBSurgeon 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 for free in this support list, sorry. Try other Firebird service providers: http://www.firebirdsql.org/en/professional-support/ may be they have free time. Regards, Alexey Kovyazin IBSurgeon *[Marius Labuschagne] * *What you doing in this forum Alexey? As far as I am aware this is a support forum, am I wrong? You promoting your business over here with all your years of experience? (Or at least you must be thinking that 12 is a very high number)* *Lets leave it at that, I would not dare ask you for any support anyway.* *Regards* *Marius* -- http://www.avast.com/ This email is free from viruses and malware because avast! Antivirusna zaščita http://www.avast.com/ protection is active.
