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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Most likely the query.
0
Scott BennettManager TechnologyCommented:
Make sure that the ArtistPage and ArtistID columns in your Artwork table are indexed.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
phillystyle123Author Commented:
i haven't done anything in cf for a while - can you give me an example of how to index them?
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Servers

From novice to tech pro — start learning today.