Slow loading cold fusion page

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

phillystyle123Asked:
Who is Participating?
 
Scott BennettConnect With a Mentor Manager TechnologyCommented:
Make sure that the ArtistPage and ArtistID columns in your Artwork table are indexed.
0
 
PluckaCommented:
Put some timing in around the different sections to see which bit is taking a long time

Most likely the query.
0
 
phillystyle123Author Commented:
i haven't done anything in cf for a while - can you give me an example of how to index them?
0
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

 
Scott BennettManager TechnologyCommented:
What database (sql server, oracle, mysql, access, etc) are you using?
0
 
phillystyle123Author Commented:
i'm using mysql
0
 
Scott BennettManager TechnologyCommented:
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
0
All Courses

From novice to tech pro — start learning today.