Hi, can you show some sample?And what indexes have you created?Can you show plan for both queries and real queries itself?What filter "where" are you using? I am really interested because i have compared both queries with much more populated tables and i have got better results time, fetches and much bigger difference was memory usage. Regards,Karol Bieniaszewski null
Re: [firebird-support] WITH RECURSIVE or not WITH RECURSIVE
liviuslivius liviusliv...@poczta.onet.pl [firebird-support] Fri, 01 Jun 2018 08:33:31 -0700
- RE: [firebird-... Omacht András aoma...@mve.hu [firebird-support]
- Re: [fire... Gabor Boros mlngl...@bgss.hu [firebird-support]
- Re: [firebird-... liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
- Re: [fire... Gabor Boros mlngl...@bgss.hu [firebird-support]
- Re: [firebird-... liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
- Re: [fire... Gabor Boros mlngl...@bgss.hu [firebird-support]
- Re: [... 'livius' liviusliv...@poczta.onet.pl [firebird-support]