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 <c...@chrisjdavis.org> 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 --~--~---------~--~----~------------~-------~--~----~ To post to this group, send email to habari-dev@googlegroups.com To unsubscribe from this group, send email to habari-dev-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/habari-dev -~----------~----~----~----~------~----~------~--~---
