[edited] logged out of admin, home page or /page/1 works OK. On Thu, Jan 29, 2009 at 8:33 PM, Stanley FONG <[email protected]> wrote:
> It cured my slowness too but my site took far too long to render home page, > i.e. mysite.com/page/1, don't know why. > mysqld is cranking less than 5% now which is normal. > > > On Thu, Jan 29, 2009 at 1:45 PM, Chris J. Davis <[email protected]>wrote: > >> >> Very nice, the update fixed the slowness for me. >> >> Thanks Owen! >> >> On Jan 28, 2009, at 11:08 PM, ringmaster wrote: >> >> > >> > This issue is a little tricky. It will behave differently when you're >> > logged in vs logged out, and may depend on how well your system >> > responded to recent permission upgrades (whether it added the tokens >> > and correctly assigned their access or not). >> > >> > In any case, assuming things went well with your upgrade regarding >> > tokens, I hope that r3078 will offer a substantial gain in speed. If >> > things didn't go well with your upgrade, you likely can't see any >> > posts when you're logged out (or worse, you get no admin at all), in >> > which case I'm sure we'd have heard from you already. >> > >> > The downside of the query is that it has the potential to return a >> > post more than once under certain conditions that the UI will not yet >> > let you create. Specifically, if you assign more than one token to a >> > post, and you have permission to access both tokens, you will see that >> > post twice. Currently, you can't assign tokens to posts. Someone >> > with more JOIN-fu than me should look at the query. It's a nasty >> > bugger, not because the query is complex, but because building it >> > based on permissions is tricky. >> > >> > Anyway, if you're running slow now, backup your database, note your >> > current rev number (svn info), and then svn up and see if there's an >> > improvement. >> > >> > Owen >> > >> > > >> >> >> >> >> > > > -- > See me at http://am.notsowise.net > -- See me at http://am.notsowise.net --~--~---------~--~----~------------~-------~--~----~ To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/habari-dev -~----------~----~----~----~------~----~------~--~---
