Aryeh Gregor schreef:
On Fri, Sep 12, 2008 at 8:47 AM, Roan Kattouw roan.kattouw@home.nl wrote:
- -- Timestamps of threaded parent and self to present a
- -- convenient threaded sort order:
- -- "20080130123456"
- -- "20080130123456,20080230123456"
- -- "20080430123456"
- --
- -- Allows 17 levels of nesting before we hit the length limit.
- -- Could redo more compactly to get 31 or 63 levels.
- cc_sortkey varbinary(255),
Nice one. What will happen when the limit is hit, though?
That *is* clever. LiquidThreads should consider something like that for thread sorting (which AFAIK must currently be done in the application). I don't think it's a big issue to limit thread depth to 63 levels, but in principle you could extend it somewhat further, up to the maximum index length.
Watch out for multibyte collations there. In the past, MW has had numerous issues with multibyte collations causing index lengths to almost double up and hit the limit.
Roan Kattouw (Catrope)