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 > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
