I think pagination is a great idea, as long as the thresholds are configurable in the admin interface.
Also, an option to close comments after X comments would be great too. In a perfect world, this would shoot an e-mail to the admin saying something like "You just got slashdotted! Throw some ads on your page right now!" :) Jesse On 6/18/05, Robby Russell <[EMAIL PROTECTED]> wrote: > > Okay, so a week later.. here is some findings of having a Typo blog > slashdotted. > > First of all, some numbers: > > > # SELECT count(id) FROM comments WHERE article_id = 53; > > count > > ------- > > 6766 > > (1 row) > > Imagine waiting for that to render and scrolling to the bottom to add > another comment. heh. It'd take long than what we have set for our > fastcgi timeout, so it'd show an error after a several hundred were > made. > > Curt emailed me to say that he hasn't been able to login to his admin > interface since the slashdotting. I believe that this might be due to > the high number of comments. I just deleted all the comments from that > entry and am awaiting him to confirm that he can now use the admin area. > > What would be a good way of handling this sort of situation with Typo? > Should we add pagination to comments? What might cause the admin area to > just not work after he types in his user/pass. Could the counts be > bogging it down long enough to timeout fcgi? > > -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 <http://www.planetargon.com> | > www.robbyonrails.com<http://www.robbyonrails.com> > *******************************************************/ > > _______________________________________________ > Typo-list mailing list > [email protected] > http://rubyforge.org/mailman/listinfo/typo-list > -- [EMAIL PROTECTED] jnewland.com <http://jnewland.com> AIM: jbnewland 706.340.3625 -------------- next part -------------- An HTML attachment was scrubbed... URL: http://rubyforge.org/pipermail/typo-list/attachments/20050618/e524ea8b/attachment.htm From robby at planetargon.com Sat Jun 18 16:53:38 2005 From: robby at planetargon.com (Robby Russell) Date: Sat Jun 18 16:49:33 2005 Subject: [typo] handling amount of comments In-Reply-To: <[EMAIL PROTECTED]> References: <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> Message-ID: <[EMAIL PROTECTED]> On Sat, 2005-06-18 at 16:43 -0400, jesse newland wrote: > Also, an option to close comments after X comments would be great too. > In a perfect world, this would shoot an e-mail to the admin saying > something like "You just got slashdotted! Throw some ads on your page > right now!" :) > Yeah, well, in this scenario, the admin wanted everyone to comment. So, shutting off comments wasn't the solution. The quick-hack-solution was to move comments to an unpublished article ever 15 minutes via crontab. -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 *******************************************************/
