nc.com [firebird-support]
Sent: Monday, September 25, 2017 7:02 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Huge performance different from FB 2.5.2 vs FB
3.02
Karol:
Not to highjack the thread, but a question. You stated:
> this is terible to read. Please ch
Karol:
Not to highjack the thread, but a question. You stated:
> this is terible to read. Please change join style to explicite join style
>
> instead SELECT .. FROM TABLE_A A, TABLE_B B WHERE A.ID=B.ID
> write SELECT .. FROM TABLE_A A INNER JOIN TABLE_B B ON A.ID=B.ID
I'm
Hi,
Thanks for the tips. I will test again with your tip.
Those Query plan created automaticaly by Firebird.
But on FB 3.0.2, it was a bad plan that hurt performance a lot.
I want to moved to FB 3, but because of this, i am hesited.
Anto.
Hi,
this is terible to read. Please change join style to explicite join style
instead SELECT .. FROM TABLE_A A, TABLE_B B WHERE A.ID=B.ID
write SELECT .. FROM TABLE_A A INNER JOIN TABLE_B B ON A.ID=B.ID
regards,
Karol Bieniaszewski
From: trsk...@yahoo.com [firebird-support]
Sent: Friday,