-----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.urlid FROM tml WHERE
(
html.urlid = urls.id
)))
);

Regards
Timo
- --
http://nentwig.biz/ (J2EE)
http://nitwit.de/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)

iD8DBQFAlm53cmRm71Um+e0RAkJuAKChd+6zoFesZfBY/cGRsSVagnJeswCeMD5s
++Es8hVsFlUpkIIsRfrBp4Y=
=STbS
-----END PGP SIGNATURE-----

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Timo Nentwig wrote:

Are you using the version 7.4.x ?



Regards
Gaetano Mendola




---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings