Help - Search - Members - Calendar
Full Version: Slow comments posting
Movable Type Community Forum > Other Product Discussion > Bugs and Odd Behavior
jesusmechicoteia
Ok, I'm almost giving up. Anytime one posts a comment to my blog (Jesus, me chicoteia!, it's in Portuguese), after clicking "POST", it takes forever to refresh the comments window. The weirdest thing: If you close the window right after pressing "POST", even though the window was not refreshd, the comment will be posted normally and I'll receive the notification mail.
I've already tried:
1. Disabling mail notification
2. Using default templates to Comments Listing, Preview and Error
3. Cleaning up the mt-comments table on MySQL

What am I missing here? I don't have a clue. Please, somebody help me.
bmk
How many templates do you have set to autorebuild?  That may be making a difference if it has to rebuild a lot of them or a really big template.
faf
one is just coming back from your site. Nice handlebars on your mascot.

one wishes just to confirm that the problem exists because one's comment took aeons to return a confirmation.

one!
jesusmechicoteia
bmk, Main Index, Master Archive Index, RS 0.91 Index, RS 1.0 Index and Stylesheet are set to autorebuild

faf, what a rude thing, mocking a foreign guy just because his English sounds a little funny... biggrin.gif
bmk
Yeesh, you're right, that takes forever. huh.gif  But it seems like all the pages are a little slow, so I wonder if it's just not the server.  Was it always like this?
jesusmechicoteia
Yes, it have been like this since I migrated to Movable Type (Before I was using Blogger, and imported everything).
This blog of mine is almost one year old (We are going to have a really BIG party to celebrate it, in case one of you guys want to come to Brazil) and I know there's a lot of stuff in it. But, goddammit, my real problem is only with the comments. I do agree that everything is slow, but comments are Waaaaaaaaaaay too slow.
bmk
I guess I don't really have any advice for you, I'm sorry.  It just seems reeeeeeeeally slow.  

Everything is good with your CGIPath in mt.cfg, right?  I'm assuming so because everything is working.  That's really just a stab in the dark.

My host once told me that mt-comments uses *the juice* on the server when it runs.  Maybe if you were able to gather some specs about your setup, what version of Perl, what type of server, stuff like that, maybe we could nail it down???  If I come up with anything I'll make sure to post it here.  Hopefully somebody else will have a suggestion also.  Please post back with any updates! *tracks topic*

faf, what is with your comment?  I don't get it and I don't care to.  But if you're picking on people, please stop.
jesusmechicoteia
Ok, I'll try to find out this details. Thanks, bmk. And be cool with faf, he's a nice guy...
bmk
Yeah, I know!  That's why I was confused what was going on here... smile.gif  Just trying to keep the peace.
jesusmechicoteia
Don't worry, we are all peaceful people. The world needs it.
I am doing some testing now. I've created a new blog on the same server and posted something. In this new blog, commentins is as fast as lightening (ok, not so much). You can take a look at http://www.jesusmechicoteia.com/teste

Now I am going to EXPORT the entries of my original blog and IMPORT them into the new one. Let's see what happens.
faf
oh sorry... i wasnt mockery... i just found it funny cos in England, the Royal family is always depicted as talking like that.

Sort of an aristocratic thing. most comics regarding the queen make her say stuff like "One did not mean to offend the people of MT Support. One wishes to send one's sincerest apologies"

one!
bmk
You may want to take a look at your templates to analyze the way you're using tags.  For instance, MTArchivelist and MTCalendar take longer to build.  If you're using something like this on every page, you would probably see a difference if you set these up as new index templates instead and included them on all the pages you want them.  That way those chunks are only generated once instead of once for every page.
jesusmechicoteia
Hey, faf, I know you weren't (wasn't?) mocking me. Forget about it. And thank you for telling me al this stuff about the uses of "one" in England. I think Monty Python guys had already done a lot of jokes with it. One more time, I ask you for forgive my bad English. I learned it from Stephen King, you know.

bmk, I think I will try it. ####, if one tells me that kicking my mom's buttass will make it work, I will do it...
jesusmechicoteia
No. Nothing seems to work. I'm going to kill myself. Or my blog.  :(
jenneth
Oh darnit, I'm having the same problems on my blog (www.jenneth.info) and I was hoping that there would be a solution by the time I read to the end of the thread. sad.gif
Regentia
Same problem on my blog, http://salt.cleric.se, and it's only when I'm posting a comment.
I've noticed the same problem on my server (the blog runs on my own server) on a phpBB2 board.
The strange thing is that this fixes itself after one or two posts on the phpBB-board, but it's the same thing all over on the weblog.

I didn't have these problems until I reinstalled the whole server and thus perl. I'm pretty convinced that it's the perl DBI / DBD::mysql thingi that's the problem, but I'm no perl guru.

Other SQL inserts, SELECTs et cetera works all fine, it just these two things that doesn't work.

perl -V gives me:
CODE
Summary of my perl5 (revision 5.0 version 8 subversion 3) configuration:
 Platform:
   osname=freebsd, osvers=4.9-release, archname=i386-freebsd
   uname='freebsd cleric.se 4.9-release freebsd 4.9-release #1: sat jan 17 01:30:58 cet 2004 root@cleric.se:usrobjusrsrcsyscleric i386 '
   config_args=''
   hint=recommended, useposix=true, d_sigaction=define
   usethreads=undef use5005threads=undef useithreads=undef usemultiplicity=undef
   useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
   use64bitint=undef use64bitall=undef uselongdouble=undef
   usemymalloc=n, bincompat5005=undef
 Compiler:
   cc='cc', ccflags ='-DHAS_FPSETMASK -DHAS_FLOATINGPOINT_H -fno-strict-aliasing -I/usr/local/include',
   optimize='-O',
   cppflags='-DHAS_FPSETMASK -DHAS_FLOATINGPOINT_H -fno-strict-aliasing -I/usr/local/include'
   ccversion='', gccversion='2.95.4 20020320 [FreeBSD]', gccosandvers=''
   intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234
   d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
   ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8
   alignbytes=4, prototype=define
 Linker and Libraries:
   ld='cc', ldflags ='-Wl,-E  -L/usr/local/lib'
   libpth=/usr/lib /usr/local/lib
   libs=-lm -lcrypt -lutil -lc
   perllibs=-lm -lcrypt -lutil -lc
   libc=, so=so, useshrplib=false, libperl=libperl.a
   gnulibc_version=''
 Dynamic Linking:
   dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=' '
   cccdlflags='-DPIC -fPIC', lddlflags='-shared  -L/usr/local/lib'


Characteristics of this binary (from libperl):
 Compile-time options: USE_LARGE_FILES
 Built under freebsd
 Compiled at Jan 19 2004 01:02:45
 @INC:
   /usr/local/lib/perl5/5.8.3/i386-freebsd
   /usr/local/lib/perl5/5.8.3
   /usr/local/lib/perl5/site_perl/5.8.3/i386-freebsd
   /usr/local/lib/perl5/site_perl/5.8.3
   /usr/local/lib/perl5/site_perl


I'm using PHP Version 4.3.4 and MySQL 4.0.17 on a FreeBSD 4.9-system.

I'll also post this reply in other related threads.
Rutty
I've had similar issues with comments taking a long time to show and even timing out. If had instances where the same comment has turned up twice even with only one button press.

I just thought it was my shabby use of templates or maybe CGI resource issues. Either way MY still works pretty well, apart from this one thing. I'll be following this thread with interest.
Regentia
PROBLEM SOLVED!!!

---

I've finally solved the problem on my server, at least!

After a couple of recompiles of PHP, MySQL, Perl and Apache I've come to the conclusion that it's perl that's freaky.

I manually removed all perl-files I could find and installed perl 5.8.3 from source (with Configure -de)
Later I installed DBI and Bundle::DBD::Mysql from source rather than via CPAN (which I did the previous times), and now it works.

So try removing the DBI and DBD Bundle for Mysql and install it from source rather than CPAN.

I'm not fully sure, but I've read that openwebmail install overwrites perl files with perltidy, creating some problems for perl. I'm running openwebmail, so maybe that was what f*cked up my system.

Hope this helps everyone else that has this problem,
cheers.

/Regentia
Somewhat-writer at salt.cleric.se
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2008 Invision Power Services, Inc.