I have a sandpit at r3402 with 722 posts that seems to be running fineon Bluehost using mySQL. It you want to bash it with a blunt instrument, feel free.
http://nbrightside.com/sandpit/ On Jan 19, 4:22 pm, "Chris Meller" <ch...@doesnthaveone.com> wrote: > 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/ae3f... > > On Mon, Jan 19, 2009 at 10:31 AM, Chris J. Davis <c...@chrisjdavis.org>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 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 -~----------~----~----~----~------~----~------~--~---
