Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#1 2008-08-15 06:54:24
- nardo
- Member
- From: tuvalahiti
- Registered: 2004-04-22
- Posts: 743
Pages with comment form load very slowly
Following results are very consistent across all pages with a comment form:
<!— Runtime: 11.321 —>
<!— Query time: 0.027634 —>
Other pages without comment form (as well as article pages with comments removed temporarily) typically show:
<!— Runtime: 0.0461 —>
<!— Query time: 0.023321 —>
Have removed ‘sbl.spamhaus.org’ from advanced preferences; all plugins are turned off; no logging; no PHP in pages. The mySQL connection works zippy on all other pages.
On a IIS server – maybe that’s the cause?? any ideas??
Offline
Re: Pages with comment form load very slowly
can you post a url?
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
Re: Pages with comment form load very slowly
And a tag trace?
It’s clearly not an SQL query causing this.
Offline
Re: Pages with comment form load very slowly
Did you mark “Use DNS lookup” to ‘No’?
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
#5 2008-08-15 09:11:40
- nardo
- Member
- From: tuvalahiti
- Registered: 2004-04-22
- Posts: 743
Re: Pages with comment form load very slowly
sorry to trouble u guys – it must be a local server environment issue … right now all pages are fast, including articles with comments:
<!— Runtime: 0.0596 —>
<!— Query time: 0.02995 —>
server/mysql load is low right now (based on our typical usage patterns)
Offline
#6 2008-08-29 01:54:03
- nardo
- Member
- From: tuvalahiti
- Registered: 2004-04-22
- Posts: 743
Re: Pages with comment form load very slowly
these runtimes are very frustrating so posting a tag trace in case someone spots a cause
the slow runtime is ONLY when comments are active on an individual post; when comments turned off, pages load quick as a flash
<!-- Runtime: 11.370 -->
<!-- Query time: 0.047062 -->
<!-- Queries: 23 -->
<!-- Memory: no info available -->
<!-- txp tag trace:
[SQL (0.008459): select name, data from txp_lang where lang='en-gb' AND ( event='public' OR event='common')]
[SQL (0.010684): select name, code, version from txp_plugin where status = 1]
[SQL (0.000969): select ID,Section from textpattern where ID = 4 and Status >= 4 limit 1]
[SQL (0.000973): select * from txp_section where name = 'archive' limit 1]
[SQL (0.002101): select *, unix_timestamp(Posted) as uPosted from textpattern where ID=4 and Status in (4,5)]
[article 4]
[SQL (0.001239): select ID, Title, url_title, unix_timestamp(Posted) as uposted
from textpattern where Posted > '2008-08-14 16:13:32' and Section = 'archive' and Status=4 and Posted < now() order by Posted asc limit 1]
[SQL (0.000925): select ID, Title, url_title, unix_timestamp(Posted) as uposted
from textpattern where Posted < '2008-08-14 16:13:32' and Section = 'archive' and Status=4 and Posted < now() order by Posted desc limit 1]
[SQL (0.000991): select user_html from txp_page where name='archive']
[Page: archive]
<txp:output_form form="header" />
[SQL (0.006810): select Form from txp_form where name='header']
[Form: header]
<txp:site_name/>
<txp:site_url/>
<txp:page_title/>
<txp:rvm_css format="link" />
[SQL (0.000572): select css from txp_section where name='archive']
<txp:site_url/>
<txp:site_url/>
<txp:site_url/>
<txp:site_name/>
<txp:site_url/>
<txp:site_url/>
<txp:site_name/>
<txp:site_slogan/>
<txp:image id="1" />
[SQL (0.001204): select * from txp_image where id = 1 limit 1]
<txp:section_list active_class="current" break="li" include_default="1" default_title="Home" wraptag="ul" />
[SQL (0.000867): select name, title from txp_section where name != 'default' order by name ASC]
<txp:if_individual_article>
[<txp:if_individual_article>: true]
<txp:article limit="1" form="archive" />
[SQL (0.000797): select Form from txp_form where name='archive']
[Form: archive]
<txp:site_url/>
<txp:site_url/>
<txp:comments_count/>
<txp:category1 title="1"/>
[SQL (0.000752): select title from txp_category where name='Participate' and type='article']
<txp:posted/>
<txp:article_image/>
[SQL (0.001098): select * from txp_image where id = 5]
<txp:title/>
<txp:link_to_prev>
[SQL (0.000855): select ID as thisid, Section as section, Title as title, url_title, unix_timestamp(Posted) as posted from textpattern where ID = 3]
<txp:prev_title/>
</txp:link_to_prev>
<txp:link_to_next>
[SQL (0.000776): select ID as thisid, Section as section, Title as title, url_title, unix_timestamp(Posted) as posted from textpattern where ID = 5]
<txp:next_title/>
</txp:link_to_next>
<txp:if_custom_field name="Flickr set number">
[<txp:if_custom_field name="Flickr set number">: false]
</txp:if_custom_field>
<txp:body/>
<txp:article form="articleform" />
[SQL (0.000494): select Form from txp_form where name='articleform']
[Form: articleform]
<txp:if_comments_allowed>
[<txp:if_comments_allowed>: true]
<txp:comments_form/>
[SQL (0.000845): select ip from txp_discuss_ipban where `ip` = '192.168.0.31' limit 1]
[SQL (0.000961): select Form from txp_form where `name` = 'comment_form' limit 1]
<txp:comments_error wraptag="ul" break="li" />
</txp:if_comments_allowed>
<txp:article form="articlecomments" />
[SQL (0.000711): select Form from txp_form where name='articlecomments']
[Form: articlecomments]
<txp:if_comments_allowed>
[<txp:if_comments_allowed>: true]
<txp:comments form="comments" />
</txp:if_comments_allowed>
</txp:if_individual_article>
<txp:output_form form="footer" />
[SQL (0.000789): select Form from txp_form where name='footer']
[Form: footer]
[ ~~~ secondpass ~~~ ]
-->
Offline
Re: Pages with comment form load very slowly
The only thing that really can be slow related to comments is DNS lookups. Is the blacklist preference completely empty? Are DNS lookups really disabled?
Offline
#8 2008-08-29 14:29:55
- nardo
- Member
- From: tuvalahiti
- Registered: 2004-04-22
- Posts: 743
Re: Pages with comment form load very slowly
Logging
– None
Spam blacklists (comma-separated)
– nothing in that field, not even a space
Use DNS lookup in visitor logs?
– No
possible that preference hasn’t updated? I deleted the spam blacklist in the preference on installation (one of the first things I do!)
Offline
Re: Pages with comment form load very slowly
Try updating to SVN changeset 2968
That changeset can be applied to 4.0.6 as well, if you can’t use a development copy of TXP.
Offline