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.