Am 24.12.2018 um 13:12 schrieb Richard Hipp:
There are now enhancements on a branch
(https://www.sqlite.org/src/timeline?r=reuse-subqueries) that should
fix your performance problem.
Since you seem to be someone who writes intense SQL, it would be
really cool if you could try out that branch
3.26.0 it takes over 6 seconds (with the full data set of around 24000
items, it seems to become infeasible).
Thanks and best,
Sebastian Bank
CREATE TABLE languoid (
id VARCHAR(8) NOT NULL,
parent_id VARCHAR(8),
PRIMARY KEY (id),
FOREIGN KEY(parent_id) REFERENCES languoid (id)
);
INSERT
2 matches
Mail list logo