Re: [sqlite] Limiting the result set size at each recursive step in a CTE

On 2019/05/07 7:57 PM, Thomas Zimmermann wrote: Hi! Sometimes it is desirable to limit the size of the queue¹ in a recursive CTE//... CREATE TABLE comment (     comment_id INTEGER PRIMARY KEY,     parent_comment_id INTEGER REFERENCES comment (comment_id),     created_at INTEGER NOT NULL --

[sqlite] Limiting the result set size at each recursive step in a CTE

Hi! Sometimes it is desirable to limit the size of the queue¹ in a recursive CTE when the domain allows for it. That puts an upper bound on processing time, even when the given table is huge. This can be achieved by adding a LIMIT clause at every step (setup and recursive). But there is my