|Subject||Re: [firebird-support] Simply bad, new is not always better. FB3 and ODBC|
because not use index.>>SS FB 3.0 takes different query plan than SC 2.5.2, it slows
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.