coppermine-gallery.com/forum

Support => Older/other versions => cpg1.3.x Support => Topic started by: CLG on November 04, 2005, 09:37:50 AM

Title: Coppermine 1.3 extremly slow > what can i do?
Post by: CLG on November 04, 2005, 09:37:50 AM
Hi,
I have installed coppermine and have designed them for my project. I added more then 30.000 Pics over batch import script. The Covers importet correctly, but when i go to the startpage the need over 1 minute to load the overview page, and all the script is very very slow.. what can i do?

I have a dedicated Server from Artfiles (Germany-Hamburg) with a P4 3,4Ghz, 1024MB RAM, fast hdd and top connection speed (all is fast, only the script is slow).

Here is the link: http://www.my-wow.com/covers/

Thank you for any Help

Greetings from Germany, Pascal
Title: Re: Coppermine 1.3 extremly slow > what can i do?
Post by: Joachim Müller on November 04, 2005, 10:03:03 AM
you have a template error that needs fixing first - this is what I get when going to your site:
QuoteTemplate error
Failed to find block 'allow_memberlist'(#(<!-- BEGIN allow_memberlist -->)(.*?)(<!-- END allow_memberlist -->)#s) in :

               
<table border="0" class="box_grau">
<tr onmouseover=this.style.background='#F0F0F0'; onmouseout=this.style.background='transparent'><td align="right" style="padding-left:12px;" width="20" class="nav"><img src="../site/files/navipfeil.gif"></td><td width="144" align="left" style="padding-left:6px;"><a href="index.php?theme=wow" title="&Uuml;bersicht" class="subnav">&Uuml;bersicht</a></td></tr>



<!-- BEGIN album_list -->
<tr onmouseover=this.style.background='#F0F0F0'; onmouseout=this.style.background='transparent'><td align="right" style="padding-left:12px;" width="20" class="nav"><img src="../site/files/navipfeil.gif"></td><td width="144" align="left" style="padding-left:6px;"><a href="{ALB_LIST_TGT}" title="{ALB_LIST_TITLE}" class="subnav">{ALB_LIST_LNK}</a></td></tr>
<!-- END album_list -->

<tr onmouseover=this.style.background='#F0F0F0'; onmouseout=this.style.background='transparent'><td align="right" style="padding-left:12px;" width="20" class="nav"><img src="../site/files/navipfeil.gif"></td><td width="144" align="left" style="padding-left:6px;"><a href="{SEARCH_TGT}" title="{SEARCH_LNK}" class="subnav">{SEARCH_LNK}</a></td></tr>





<!-- BEGIN faq -->
<tr onmouseover=this.style.background='#F0F0F0'; onmouseout=this.style.background='transparent'><td align="right" style="padding-left:12px;" width="20" class="nav"><img src="../site/files/navipfeil.gif"></td><td width="144" align="left" style="padding-left:6px;"><a href="{FAQ_TGT}" title="{FAQ_TITLE}" class="subnav">{FAQ_LNK}</a></td></tr>
<!-- END faq -->

<!-- BEGIN upload_pic -->
<tr onmouseover=this.style.background='#F0F0F0'; onmouseout=this.style.background='transparent'><td align="right" style="padding-left:12px;" width="20" class="nav"><img src="../site/files/navipfeil.gif"></td><td width="144" align="left" style="padding-left:6px;"><a href="{UPL_PIC_TGT}" title="{UPL_PIC_TITLE}" class="subnav">{UPL_PIC_LNK}</a></td></tr>
<!-- END upload_pic -->

<tr onmouseover="this.style.background='#F0F0F0';" onmouseout="this.style.background='transparent'"><td align="right" style="padding-left:12px;" width="20" class="nav"><img src="../site/files/navipfeil_back.gif"></td><td width="144" align="left" style="padding-left:6px;"><a href=javascript:history.back(); class="subnav" style="color:#2954C3">zur&uuml;ck</a></td></tr>

</table>
<table cellpadding="0" cellspacing="0" border="0"  width="100%" height="100%">
<tr>
    <td><img src="../site/files/2px_w.gif" width="159" height="2" alt="" border="0"></td>
</tr>
<tr>
    <td class="titelbox_blau">&nbsp;&nbsp;Submenü</td>
</tr>
<tr>
    <td><img src="../site/files/3px_w.gif" width="159" height="3" alt="" border="0"></td>
</tr>
</table>


<table border="0">
<!-- BEGIN register -->
<tr onmouseover=this.style.background='#F0F0F0'; onmouseout=this.style.background='transparent'><td align="right" style="padding-left:12px;" width="20" class="nav"><img src="../site/files/navipfeil.gif"></td><td width="144" align="left" style="padding-left:6px;"><a href="{REGISTER_TGT}" title="{REGISTER_TITLE}" class="subnav" style="color:#2954C3;">{REGISTER_LNK}</a></td></tr>
<!-- END register -->

<!-- BEGIN login -->
<tr onmouseover=this.style.background='#F0F0F0'; onmouseout=this.style.background='transparent'><td align="right" style="padding-left:12px;" width="20" class="nav"><img src="../site/files/navipfeil.gif"></td><td width="144" align="left" style="padding-left:6px;"><a href="{LOGIN_TGT}" class="subnav">{LOGIN_LNK}</a></td></tr>
<!-- END login -->







<tr onmouseover=this.style.background='#F0F0F0'; onmouseout=this.style.background='transparent'><td align="right" style="padding-left:12px;" width="20" class="nav"><img src="../site/files/navipfeil.gif"></td><td width="144" align="left" style="padding-left:6px;"><a href="{LASTUP_TGT}" title="{LASTUP_LNK}" class="subnav">{LASTUP_LNK}</a></td></tr>

</table>

Your page indeed loads very slow - usually the culprit is an extremely large number of details and subsequent queries that need to be run. Did you customize anything code-wise or is your install (except the custom theme) out-of-the-box? I don't think so, as running your site with the classic theme (http://www.my-wow.com/covers/index.php?theme=classic) displays a different index page - you appear to have enabled additional stats (see attached screenshot), which imo could be the culprit. Temporarily undo your modifications (remember to backup) and check if this fixes your performance issues.