On Fri, Sep 12, 2008 at 8:47 AM, Roan Kattouw <roan.kattouw(a)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.