This was also reported on -users [1], so you're not the only one having the problem. FWIW, my first guess would be that it's the JOIN to get the posts each user can view causing the problem. I imagine on localhost you only had a handful of posts, but on your live blog you have many thousands more. It might be worth using the Lipsum plugin to generate a couple thousand posts on your local machine, just to confirm...
Here's hoping someone like Jay Pipes can optimize our query with his MySQL foo and we don't have to take another approach. [1] http://groups.google.com/group/habari-users/browse_thread/thread/ae3f53c275e928c3 On Mon, Jan 19, 2009 at 10:31 AM, Chris J. Davis <[email protected]>wrote: > > I tested the new code on localhost, found no issues and upgraded two > of my sites. cjd.org is now noticeably slower after the update. I have > tested both logged in and logged out, and there is quote a bit of > delay now. > > Just thought I would pass this on. I haven't had time to look at how > the ACL stuff has been constructed, so I can't offer any insight/ > suggestions at this time. > > Chris > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
