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.
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)