Timo Nentwig wrote:
This is very slow:
SELECT urls.id FROM urls WHERE
(
urls.id <> ALL (SELECT html.urlid FROM html)
);
...while this is quite fast:
SELECT urls.id FROM urls WHERE
(
NOT (EXISTS (SELECT html.urlid FROM tml WHERE
(
html.urlid = urls.id
)))
);
Are you using the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi!
Your bug report form on the web doesn't work.
This is very slow:
SELECT urls.id FROM urls WHERE
(
urls.id <> ALL (SELECT html.urlid FROM html)
);
...while this is quite fast:
SELECT urls.id FROM urls WHERE
(
NOT (EXISTS (SELECT html.