| Subject | Re: AW: AW: [firebird-support] Simply bad, new is not always better. FB3 and ODBC |
|---|---|
| Author | |
| Post date | 2016-05-14T05:01:03Z |
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
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