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