Hi HTH,
thanks for the detailed explainations. I "inherited" the sql code but updated the firebird version. And was wondering what was ruining the performance. Basically I want the set of first 10 entries but without 2 with a special property. I will just query the first 10 then and remove the unwanted programattically in the application. The query for the first 10 is only 0.8s... So this will greatly improve the thing with the old and new version. Of course theoretically comparing two sets can be expensive. Thanks for the profound answers!!! Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] < firebird-support@yahoogroups.com> schrieb am Sa., 25. Jan. 2020, 11:27: > 25.01.2020 07:59, Matthias Winkler spmm...@gmail.com [firebird-support] > wrote: > > The major problem is, that with firebird 2.1.3 the query also completes > within 3 seconds. > > Something seems to have changed with the optimizer, execution plan or > whatever (~ sorry I > > dont know the terms here) > > related to sorting, or double sorting, or sorting within "sub"-queries. > > Yes, somewhere there was fixed a bug producing wrong query result if > NOT IN was used. > > > -- > WBR, SD. > > > ------------------------------------ > > ------------------------------------ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > Visit http://www.firebirdsql.org and click the Documentation item > on the main (top) menu. Try FAQ and other links from the left-side menu > there. > > Also search the knowledgebases at > http://www.ibphoenix.com/resources/documents/ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > ------------------------------------ > > Yahoo Groups Links > > > >
