-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi,
- -- "Joe \"Nuke Me Xemu\" Foster" <[EMAIL PROTECTED]> wrote: > Here's an alternative which may not perform very well but may > still be better than risking a full table-scan... I use exactly this method in a forum software, and it performs VERY good. I tested it with about a million of rows, and it is really very fast. Even with deep trees (1000 sub branches). The only difference is that I use a base 255 encoded text column instead of only 0-9. But attention: the character set must be ASCII (ordering!) ... I want to change this to bytea to avoid base255 encoding and the character set problems, but there are still some Bugs with bytea and the like operator. :-( Ciao Alvar - -- ** Alvar C.H. Freude -- http://alvar.a-blast.org/ -- http://odem.org/ ** Berufsverbot? http://odem.org/aktuelles/staatsanwalt.de.html ** ODEM.org-Tour: http://tour.odem.org/ ** Informationsgesellschaft: http://www.wsis-koordinierungskreis.de/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (FreeBSD) iD4DBQE/z59nOndlH63J86wRAsrEAJ9OjO5fXhnw2mmLoB7YNHJFYO/X8QCXc31M FWdV8T92N3kzctSgOOkVMw== =Uwtm -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
