Re: MS Access to MS SQL Performance Problems

[Dennis Longnecker]

I wanted to add something else....In the application that processes the query, it does some embedded queries...

<cfloop query="Get_Memberlist">
<tr>
<td align=right>&nbsp;#counter#&nbsp;</td>
<td>#LastDate#<td>
<cfquery name="get_president" datasource="gyro4_Members">
SELECT *
FROM roster
where (club = '#Get_Memberlist.Club#' and (position_club like 'PRE%' OR position_club like '%,PRE%'))
</cfquery>
<td>#get_president.FName# #get_president.Surname#</td>
<cfquery name="Get_Membercount" Datasource="gyro4_Members">
SELECT club
FROM roster
WHERE Club = '#Get_memberlist.Club#'
</cfquery>
<td align=right>#Get_Membercount.RecordCount#</td>
<td align=right>#Year_Chartered#</td>
</cfloop>