{"version":"1.0","provider_name":"Rainbow Dash Network","provider_url":"http:\/\/rainbowdash.net\/","type":"link","title":"Toksyuryel (toksyuryel)'s status on Monday, 14-May-12 09:32:33 UTC","author_name":"Toksyuryel (toksyuryel)","author_url":"http:\/\/rainbowdash.net\/toksyuryel","url":"http:\/\/rainbowdash.net\/notice\/1379076","html":"Pre-caching the path instead of generating it dynamically seems to only improve cached performance (though the improvement there is dramatic). In some cases the uncached performance was actually *worse* than generating the path in a WITH RECURSIVE block. <a href=\"http:\/\/pgsql.privatepaste.com\/60741d539f\" title=\"http:\/\/pgsql.privatepaste.com\/60741d539f\" rel=\"nofollow external\">http:\/\/pgsql.privatepaste.com\/60741d539f<\/a> @<span class=\"vcard\"><a href=\"http:\/\/rainbowdash.net\/user\/10428\" class=\"url\" title=\"Bit Shift\"><span class=\"fn nickname\">bitshift<\/span><\/a><\/span> @<span class=\"vcard\"><a href=\"http:\/\/rainbowdash.net\/user\/2959\" class=\"url\" title=\"The Pony Formerly Known As Ponydude\"><span class=\"fn nickname\">widget<\/span><\/a><\/span> !<span class=\"vcard\"><a href=\"http:\/\/rainbowdash.net\/group\/878\/id\" class=\"url\" title=\"Coder Ponies! (coderpony)\"><span class=\"fn nickname\">coderpony<\/span><\/a><\/span> #<span class=\"tag\"><a href=\"http:\/\/rainbowdash.net\/tag\/sql\" rel=\"tag\">SQL<\/a><\/span>"}