Chris: Are you using MySQL or SQLite? On Mon, Jan 19, 2009 at 1:19 PM, Andy C <andyc...@gmail.com> wrote:
> > 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 -~----------~----~----~----~------~----~------~--~---
