Hi, >>SS FB 3.0 takes different query plan than SC 2.5.2, it slows because not use >>index. 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 From: mailto:firebird-support@yahoogroups.com Sent: Saturday, May 14, 2016 7:01 AM To: firebird-support@yahoogroups.com 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