I am using mysql. On Jan 19, 2009, at 12:36 PM, Chris Meller wrote:
> 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 -~----------~----~----~----~------~----~------~--~---
