| Subject | Re: [firebird-support] WITH RECURSIVE or not WITH RECURSIVE |
|---|---|
| Author | Gabor Boros |
| Post date | 2018-06-01T12:04:52Z |
2018. 05. 31. 21:00 keltezéssel, Gabor Boros mlnglsts@...
[firebird-support] írta:
from FlameRobin:
Your:
37295446 fetches, 0 marks, 0 reads, 0 writes.
0 inserts, 0 updates, 0 deletes, 0 index, 33029478 seq.
Delta memory: 112872 bytes.
Total execution time: 26.243s
Andras+Mark:
2529 fetches, 0 marks, 97 reads, 0 writes.
0 inserts, 0 updates, 0 deletes, 73 index, 2018 seq.
Delta memory: 419464 bytes.
Total execution time: 0.051s
Gabor
[firebird-support] írta:
> 2018. 05. 30. 20:03 keltezéssel, 'livius' liviuslivius@...Sorry Karol! Your solution is slow with my real database. Some numbers
> [firebird-support] írta:
>> Hi,
>>
>> better is walk throught tree
>
>
> What a simplicity! :-) Thank you very much Karol!
from FlameRobin:
Your:
37295446 fetches, 0 marks, 0 reads, 0 writes.
0 inserts, 0 updates, 0 deletes, 0 index, 33029478 seq.
Delta memory: 112872 bytes.
Total execution time: 26.243s
Andras+Mark:
2529 fetches, 0 marks, 97 reads, 0 writes.
0 inserts, 0 updates, 0 deletes, 73 index, 2018 seq.
Delta memory: 419464 bytes.
Total execution time: 0.051s
Gabor