| Subject | Re: [firebird-support] Simply bad, new is not always better. FB3 and ODBC |
|---|---|
| Author | |
| Post date | 2016-05-14T07:05:10Z |
Hi,
because not use index.>>SS FB 3.0 takes different query plan than SC 2.5.2, it slows
will be good to see query, query plan in both FB versions – if you need
help you must help others to help you (with exact info).
Also will be good to see indexes and its statistics
regards,
Karol Bieniaszewski
Sent: Saturday, May 14, 2016 7:01 AM
Subject: Re: AW: AW: [firebird-support] Simply bad, new is not
always better. FB3 and ODBC
From SC FB 2.5.2 to SS FB 3.0, all on Win64, I can confirm 2 things
:
1) Post Event on SS 3.0, sometimes works, sometime not. I have an app that
use post_event. Sometime I have to restart this app a few times to make
post_event works.
2) Stored Procedure/Query
I have noticed that
SP/Query that runs very slow on SS FB 3.0 has an in clause. (perhaps there are
other type of query that could cause this). SS FB 3.0 takes different
query plan than SC 2.5.2, it slows because not use
index.
Regards,
Anto