We help IT Professionals succeed at work.

Slow loading cold fusion page

phillystyle123
on
Medium Priority
1,197 Views
Last Modified: 2013-12-24
hi, the following page (see snippet)takes forever to load - none of the other cf pages on the site are problematic - and this one doesn't have any graphics - please advise! thanks in advance!!!
<HTML>
<cfquery name="Artists" datasource="Ikonltd">
SELECT Artists.FirstName, Artists.LastName, Artists.ArtistID, Artwork.ArtistPage, Artwork.sm 
FROM Artists, Artwork 
Where Artists.ArtistID=Artwork.ArtistID and Artwork.ArtistPage = <CFQUERYPARAM CFSQLTYPE="cf_sql_numeric" VALUE="1">
GROUP BY Artists.LastName ORDER BY Artists.LastName Asc 
</cfquery>
 
 
 
<!-- InstanceBegin template="/Templates/interiorpages.dwt.cfm" codeOutsideHTMLIsLocked="false" -->
<HEAD>
<!-- InstanceBeginEditable name="doctitle" -->
<TITLE>IKON Ltd Contemporary Art Gallery</TITLE>
<!-- InstanceEndEditable --> 
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<link href="../css/ikonltd.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
a:link.navbar {
	font-family: Arial, Helvetica, sans-serif;
	font-size: 12px;
	font-weight: bold;
	color: #FFFFFF;
	text-decoration: none;
}
a:hover.navbar {
 
	font-family: Arial, Helvetica, sans-serif;
	font-size: 12px;
	font-weight: bold;
	color: #FFFFFF;
	text-decoration: underline;
}
a:visited.navbar {
 
 
	font-family: Arial, Helvetica, sans-serif;
	font-size: 12px;
	font-weight: bold;
	color: #FFFFFF;
	text-decoration: none;
}
a:hover.navbar {
 
	font-family: Arial, Helvetica, sans-serif;
	font-size: 12px;
	font-weight: bold;
	color: #FFFFFF;
	text-decoration: underline;
}
 
-->
</style>
<!-- InstanceBeginEditable name="head" --><!-- InstanceEndEditable -->
</HEAD>
<BODY BGCOLOR=#FFFFFF>
<TABLE WIDTH=760 BORDER=0 CELLPADDING=0 CELLSPACING=0 align="center">
  <TR> 
    <TD COLSPAN=3> <IMG SRC="../images/pageelements/header1.gif" WIDTH=760 HEIGHT=143 border="0" usemap="#Map"></TD>
  </TR>
  <TR> 
    <TD bgcolor="#9EA6C9"> <IMG SRC="../images/spacer.gif" WIDTH=8 HEIGHT=27></TD>
    <TD bgcolor="#9EA6C9"> <table width="739" border="0" cellspacing="0" cellpadding="0">
        <tr> 
          <td valign="top"><img src="../images/spacer.gif" width="739" height="1"></td>
        </tr>
        <tr> 
          <td valign="top" align="center"><a href="../current/indexnew.cfm" class="navbar">CURRENT 
            EXHIBITION</a>&nbsp;&nbsp;&nbsp;<a href="../past/index.cfm" class="navbar">PAST 
            EXHIBITIONS</a>&nbsp;&nbsp;&nbsp;<a href="index.cfm" class="navbar">ARTISTS</a>&nbsp;&nbsp;&nbsp;<a href="../newaq/index.cfm" class="navbar">NEW 
            ACQUISITIONS</a>&nbsp;&nbsp;&nbsp;<a href="../privateroom/index.cfm" class="navbar">PRIVATE 
            ROOM</a>&nbsp;&nbsp;&nbsp;<a href="../about/index.cfm" class="navbar">ABOUT</a>&nbsp;&nbsp;&nbsp;<a href="../contact/index.cfm" class="navbar">CONTACT</a>&nbsp;&nbsp;&nbsp;<a href="../index.cfm" class="navbar">HOME</a></td>
        </tr>
      </table></TD>
    <TD bgcolor="#9EA6C9"> <IMG SRC="../images/spacer.gif" WIDTH=13 HEIGHT=27></TD>
  </TR>
  <TR> 
    <TD COLSPAN=3> <IMG SRC="../images/pageelements/whitespace5.gif" WIDTH=760 HEIGHT=16></TD>
  </TR>
  <TR valign="top"> 
    <TD COLSPAN=3> <table width="760" border="0" cellspacing="0" cellpadding="0">
        <tr> 
          <td valign="top"><img src="../images/spacer.gif" width="760" height="1"></td>
        </tr>
        <tr> 
          <td valign="top"><table width="760" border="0" cellspacing="0" cellpadding="0">
              <tr> 
                <td width="10" valign="top"><img src="../images/spacer.gif" width="1" height="343"></td>
                <!-- InstanceBeginEditable name="content" --> 
                
<td width="750" valign="top">
				<table width="398" border="0" cellspacing="0" cellpadding="0" class="tblborderGray" align="center">
  
<tr>
    
<td valign="top" bgcolor="#333333" style="padding:5px 0px 5px 0px;"><p align="center" class="uppercasetext"><font color="#FFFFFF"><b>ARTISTS</b></font></p></td>
</tr>
  
</table>
				
				<table width="30%" border="0" cellspacing="1" cellpadding="1" align="left"><tr>
<td valign="top" colspan="4">&nbsp;</td>
</tr>
                    
 
<tr>
<cfoutput query="Artists">
    <cfquery name="getArtistImage" datasource="Ikonltd" maxrows="1">
           SELECT Artwork.sm, AutoArtID
           FROM  Artwork 
           Where ArtistID = <CFQUERYPARAM CFSQLTYPE="cf_sql_numeric" VALUE="#Artists.ArtistID#"> and Artwork.ArtistPage = <CFQUERYPARAM CFSQLTYPE="cf_sql_numeric" VALUE="1"> 
   </cfquery>
   
   <cfset sFname = Artists.FirstName>
   <cfset sLname = Artists.LastName>
   <cfset nArtistID = Artists.ArtistID>
   <cfset nAutoArtID = getArtistImage.AutoArtID>
<cfloop  query="getArtistImage">
     <td width="5%" valign="top"><img src="../images/spacer.gif" width="50" height="50"></td>
</cfloop>
     <td width="88%"><p class="artistname"><a href="artist.cfm?ArtistID=#nArtistID#"><b>#sFname#&nbsp;#sLname#</b></a></p></td>
<td valign="top"><img src="../images/spacer.gif" width="5" height="3"></td>
<cfif not Artists.currentRow mod 4>
</tr>
<tr>
</cfif> 
</cfoutput>
</tr>
</table> 
 
 
 
<br>
                    </td>
                <!-- InstanceEndEditable --></tr>
            </table></td>
        </tr>
      </table></TD>
  </TR>
  <TR> 
    <TD COLSPAN=3> <IMG SRC="../images/pageelements/footer7.gif" WIDTH=760 HEIGHT=25></TD>
  </TR>
</TABLE>
<map name="Map">
  <area shape="rect" coords="2,2,281,143" href="../index.cfm" alt="IKON Ltd. Contemporary Art">
</map>
</BODY>
<!-- InstanceEnd --></HTML>

Open in new window

Comment
Watch Question

Commented:
Put some timing in around the different sections to see which bit is taking a long time

Most likely the query.
Manager Technology
Commented:
Make sure that the ArtistPage and ArtistID columns in your Artwork table are indexed.

Author

Commented:
i haven't done anything in cf for a while - can you give me an example of how to index them?
Scott BennettManager Technology

Commented:
What database (sql server, oracle, mysql, access, etc) are you using?

Author

Commented:
i'm using mysql
Scott BennettManager Technology

Commented:
You can find the the CREATE INDEX Syntax for mysql at this url:

http://dev.mysql.com/doc/refman/5.0/en/create-index.html

Explore More ContentExplore courses, solutions, and other research materials related to this topic.