Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#1 2008-03-09 23:09:08
- ideoplex
- New Member
- Registered: 2008-03-09
- Posts: 2
Contact form display very slow after upgrading from 4.0.4 to 4.0.6
After upgrading from 4.0.4 to 4.0.6, I noticed that the display of posts with comments enabled is much slower than that of posts w/o comments. This is most easily seen at my contact page (I use moderated comments to disguise my email address). Runtime is about 80.0 seconds with the txp:comments_form included and about 0.02 without. This particular post has multiple unapproved comments.
I include the trace information below (first with, then without)
<pre>
<!— Runtime: 80.190 —>
<!— Query time: 0.096443 —>
<!— Queries: 16 —>
<!— Memory: 2131Kb, <txp:comments_help /> —>
<!— txp tag trace:
[SQL (0.039824): select name, data from txp_lang where lang=‘en-us’ AND ( event=‘public’ OR event=‘common’)]
[SQL (0.020667): select name, code, version from txp_plugin where status = 1]
[SQL (0.000692): select ID,Section from textpattern where ID = 1257 and Status >= 4 limit 1]
[SQL (0.004478): select * from txp_section where name = ‘ztatic’ limit 1]
[SQL (0.001968): select *, unix_timestamp(Posted) as uPosted from textpattern where ID=1257 and Status in (4,5)]
[article 1257]
[SQL (0.006036): select ID, Title, url_title, unix_timestamp(Posted) as uposted
from textpattern where Posted > ’2006-12-17 16:01:37’ and Section = ‘ztatic’ and Status=4 and Posted < now() order by Posted asc limit 1]
[SQL (0.004979): select ID, Title, url_title, unix_timestamp(Posted) as uposted
from textpattern where Posted < ’2006-12-17 16:01:37’ and Section = ‘ztatic’ and Status=4 and Posted < now() order by Posted desc limit 1]
[SQL (0.00669): select user_html from txp_page where name=‘Ztatic’]
[Page: Ztatic]
<txp:css/>
<txp:page_title/>
<txp:site_name/>
<txp:site_slogan/>
<txp:if_category>
[<txp:if_category>: false]
</txp:if_category>
<txp:if_search>
[<txp:if_search>: false]
</txp:if_search>
<txp:article listform=“Zingle” form=“Zingle” limit=“7” />
[SQL (0.000461): select Form from txp_form where name=‘Zingle’]
[Form: Zingle]
<txp:article_id/>
<txp:title/>
<txp:posted format=”%d %b %Y, %H:%M” />
<txp:article_image/>
<txp:body/>
[SQL (0.000230): select Form from txp_form where name=‘comments_display’]
[Form: comments_display]
<txp:if_comments_allowed>
[<txp:if_comments_allowed>: true]
<txp:comments/>
<txp:comments_form/>
[SQL (0.000205): select ip from txp_discuss_ipban where `ip` = ’67.86.12.239’ limit 1]
[SQL (0.000097): select Form from txp_form where `name` = ‘comment_form’ limit 1]
<txp:comments_error wraptag=“ul” break=“li” />
<txp:comments_help/>
</txp:if_comments_allowed>
<txp:if_article_list>
[<txp:if_article_list>: false]
</txp:if_article_list>
<txp:linklist break=“li” wraptag=“ul” />
[SQL (0.002790): select *, unix_timestamp(date) as uDate from txp_link where 1=1 order by linksort asc ]
[SQL (0.001942): select Form from txp_form where name=‘plainlinks’]
[Form: plainlinks]
<txp:linkdesctitle/>
[Form: plainlinks]
<txp:linkdesctitle/>
[Form: plainlinks]
<txp:linkdesctitle/>
[Form: plainlinks]
<txp:linkdesctitle/>
[Form: plainlinks]
<txp:linkdesctitle/>
[Form: plainlinks]
<txp:linkdesctitle/>
[Form: plainlinks]
<txp:linkdesctitle/>
[Form: plainlinks]
<txp:linkdesctitle/>
[Form: plainlinks]
<txp:linkdesctitle/>
<txp:output_form form=“footer” />
[SQL (0.004268): select Form from txp_form where name=‘footer’]
[Form: footer]
<txp:sed_copyright/>
[ ~~~ secondpass ~~~ ]
<!— Runtime: 0.0188 —>
<!— Query time: 0.00513 —>
<!— Queries: 14 —>
<!— Memory: 2113Kb, <txp:linkdesctitle /> —>
<!— txp tag trace:
[SQL (0.001168): select name, data from txp_lang where lang=‘en-us’ AND ( event=‘public’ OR event=‘common’)]
[SQL (0.000268): select name, code, version from txp_plugin where status = 1]
[SQL (0.000117): select ID,Section from textpattern where ID = 1257 and Status >= 4 limit 1]
[SQL (0.000120): select * from txp_section where name = ‘ztatic’ limit 1]
[SQL (0.000246): select *, unix_timestamp(Posted) as uPosted from textpattern where ID=1257 and Status in (4,5)]
[article 1257]
[SQL (0.000633): select ID, Title, url_title, unix_timestamp(Posted) as uposted
from textpattern where Posted > ’2006-12-17 16:01:37’ and Section = ‘ztatic’ and Status=4 and Posted < now() order by Posted asc limit 1]
[SQL (0.000449): select ID, Title, url_title, unix_timestamp(Posted) as uposted
from textpattern where Posted < ’2006-12-17 16:01:37’ and Section = ‘ztatic’ and Status=4 and Posted < now() order by Posted desc limit 1]
[SQL (0.000103): select user_html from txp_page where name=‘Ztatic’]
[Page: Ztatic]
<txp:css/>
<txp:page_title/>
<txp:site_name/>
<txp:site_slogan/>
<txp:if_category>
[<txp:if_category>: false]
</txp:if_category>
<txp:if_search>
[<txp:if_search>: false]
</txp:if_search>
<txp:article listform=“Zingle” form=“Zingle” limit=“7” />
[SQL (0.000209): select Form from txp_form where name=‘Zingle’]
[Form: Zingle]
<txp:article_id/>
<txp:title/>
<txp:posted format=”%d %b %Y, %H:%M” />
<txp:article_image/>
<txp:body/>
[SQL (0.000209): select Form from txp_form where name=‘comments_display’]
[Form: comments_display]
<txp:if_comments_allowed>
[<txp:if_comments_allowed>: true]
<txp:comments/>
</txp:if_comments_allowed>
<txp:if_article_list>
[<txp:if_article_list>: false]
</txp:if_article_list>
<txp:linklist break=“li” wraptag=“ul” />
[SQL (0.000155): select *, unix_timestamp(date) as uDate from txp_link where 1=1 order by linksort asc ]
[SQL (0.000184): select Form from txp_form where name=‘plainlinks’]
[Form: plainlinks]
<txp:linkdesctitle/>
[Form: plainlinks]
<txp:linkdesctitle/>
[Form: plainlinks]
<txp:linkdesctitle/>
[Form: plainlinks]
<txp:linkdesctitle/>
[Form: plainlinks]
<txp:linkdesctitle/>
[Form: plainlinks]
<txp:linkdesctitle/>
[Form: plainlinks]
<txp:linkdesctitle/>
[Form: plainlinks]
<txp:linkdesctitle/>
[Form: plainlinks]
<txp:linkdesctitle/>
<txp:output_form form=“footer” />
[SQL (0.000174): select Form from txp_form where name=‘footer’]
[Form: footer]
<txp:sed_copyright/>
[ ~~~ secondpass ~~~ ]
—>
</pre>
Offline
Re: Contact form display very slow after upgrading from 4.0.4 to 4.0.6
head to admin -> preferences -> advanced -> comments -> ‘spam blacklists’ and clear out that field. see if that changes anything.
Last edited by iblastoff (2008-03-09 23:12:18)
Offline
#3 2008-03-09 23:16:21
- ideoplex
- New Member
- Registered: 2008-03-09
- Posts: 2
Re: Contact form display very slow after upgrading from 4.0.4 to 4.0.6
iblastoff wrote:
head to admin -> preferences -> advanced -> comments -> ‘spam blacklists’ and clear out that field. see if that changes anything.
Bingo. Clearing out sbl.spamhaus.org fixed the problem.
Offline
#4 2008-03-10 07:54:57
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: Contact form display very slow after upgrading from 4.0.4 to 4.0.6
This is a FAQ so point people to it.
Offline