phillystyle123
asked on
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> <a href="../past/index.cfm" class="navbar">PAST
EXHIBITIONS</a> <a href="index.cfm" class="navbar">ARTISTS</a> <a href="../newaq/index.cfm" class="navbar">NEW
ACQUISITIONS</a> <a href="../privateroom/index.cfm" class="navbar">PRIVATE
ROOM</a> <a href="../about/index.cfm" class="navbar">ABOUT</a> <a href="../contact/index.cfm" class="navbar">CONTACT</a> <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"> </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# #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>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
i haven't done anything in cf for a while - can you give me an example of how to index them?
What database (sql server, oracle, mysql, access, etc) are you using?
ASKER
i'm using mysql
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
http://dev.mysql.com/doc/refman/5.0/en/create-index.html
Most likely the query.