[typo] High load

[Tobias Luetke]

Thats some good data.

I guess the solution to this is to make all of typos pages static. We
already have the  beginnings of a "posted xx minutes ago" javascript
so this should be possible.

On 6/11/05, Robby Russell <robby at planetargon.com> wrote:
> On Sat, 2005-06-11 at 09:59 -0700, Robby Russell wrote:
> > Just a FYI.
> >
> > Curt was nice enough to get slashdotted this morning, probably making
> > his blog the first one to have that done to.
> >
> > Well, it seems that when you hit 400+ comments on a single typo post, it
> > starts to bog the server down quite a bit. :-)
> >
> > Might need to do some query optimizing once this blows over.
> >
> > -Robby
> >
> 
> It looks like first of all his blog was set in 'development' mode.
> Switched that to production.. helped..a little.
> 
> What I've had to do is create an unpublished article and move comments
> to it every so often.
> 
> curthibbs_typo=# SELECT count(id) FROM comments WHERE article_id = 53;
>  count
> -------
>    939
> 
> Typo doesn't run efficiently when we get more than a few hundred
> comments X slashdot crowd. :-)
> 
> -Robby
> 
> --
> /******************************************************
> * Robby Russell, Owner.Developer.Geek
> * PLANET ARGON, Open Source Solutions & Web Hosting
> * Portland, Oregon | p: 503.351.4730 | f: 815.642.4068
> * www.planetargon.com | www.robbyonrails.com
> *******************************************************/
> 
> _______________________________________________
> Typo-list mailing list
> Typo-list at rubyforge.org
> http://rubyforge.org/mailman/listinfo/typo-list
> 


-- 
Tobi
http://www.snowdevil.ca - Snowboards that don't suck
http://typo.leetsoft.com - Open source weblog engine
http://blog.leetsoft.com - Technical weblog