This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C0182B.FDF468CC
Content-Type: text/plain;
charset="iso-8859-1"
Hello!
OT: Does anyone know how I can turn off MIME formatting when I send these
messages? Every preference I check says "plain text", but my messages always
get converted to MIME/HTML when they're sent out to the list.
WinNT4/Outlook2K. Reply OTL, THX.
>From: "Bud" <[EMAIL PROTECTED]>
>Which is faster? I'm presuming count() or what else would it be good for?
I thought I'd take a stab at this comparison and see what happened for me.
All I need to do with this query is to output the number of records
returned.
My original query looked like this and took 72ms on average.
The number of records was output as #DBCodes.RecordCount#.
<cfquery name="DBCodes" datasource="#datasource#">
SELECT CODE
FROM REFERRAL_CODE
ORDER BY CODE ASC
</cfquery>
The new query looks like this and takes 8ms on average.
The number of records is output as #DBCodes.TotalRecords#.
<cfquery name="DBCodes" datasource="#datasource#">
SELECT Count(*) AS TotalRecords
FROM REFERRAL_CODE
</cfquery>
So, in my case, using the tips and techniques I've picked up from this list,
I've reduced the time this particular page takes to load by about 64ms, and
since the *entire page* takes 320ms to execute on average, that's a pretty
big savings! I love this place. :-)
Thanks all, and keep 'em coming!
Matthew
------_=_NextPart_001_01C0182B.FDF468CC
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>RE: count() or recordcount</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>Hello!</FONT>
</P>
<P><FONT SIZE=3D2>OT: Does anyone know how I can turn off MIME =
formatting when I send these messages? Every preference I check says =
"plain text", but my messages always get converted to =
MIME/HTML when they're sent out to the list. WinNT4/Outlook2K. Reply =
OTL, THX.</FONT></P>
<P><FONT SIZE=3D2>>From: "Bud" =
<[EMAIL PROTECTED]></FONT>
<BR><FONT SIZE=3D2>>Which is faster? I'm presuming count() or what =
else would it be good for?</FONT>
</P>
<P><FONT SIZE=3D2>I thought I'd take a stab at this comparison and see =
what happened for me.</FONT>
<BR><FONT SIZE=3D2>All I need to do with this query is to output the =
number of records returned.</FONT>
</P>
<P><FONT SIZE=3D2>My original query looked like this and took 72ms on =
average.</FONT>
<BR><FONT SIZE=3D2>The number of records was output as =
#DBCodes.RecordCount#.</FONT>
</P>
<P><FONT SIZE=3D2><cfquery name=3D"DBCodes" =
datasource=3D"#datasource#"></FONT>
<BR> <FONT =
SIZE=3D2>SELECT CODE</FONT>
<BR> <FONT =
SIZE=3D2>FROM =
REFERRAL_CODE</FONT>
<BR> <FONT SIZE=3D2>ORDER BY =
CODE ASC</FONT>
<BR><FONT SIZE=3D2></cfquery></FONT>
</P>
<P><FONT SIZE=3D2>The new query looks like this and takes 8ms on =
average.</FONT>
<BR><FONT SIZE=3D2>The number of records is output as =
#DBCodes.TotalRecords#.</FONT>
</P>
<P><FONT SIZE=3D2><cfquery name=3D"DBCodes" =
datasource=3D"#datasource#"></FONT>
<BR> <FONT =
SIZE=3D2>SELECT Count(*) AS TotalRecords</FONT>
<BR> <FONT =
SIZE=3D2>FROM =
REFERRAL_CODE</FONT>
<BR><FONT SIZE=3D2></cfquery></FONT>
</P>
<P><FONT SIZE=3D2>So, in my case, using the tips and techniques I've =
picked up from this list, I've reduced the time this particular page =
takes to load by about 64ms, and since the *entire page* takes 320ms to =
execute on average, that's a pretty big savings! I love this place. =
:-)</FONT></P>
<P><FONT SIZE=3D2>Thanks all, and keep 'em coming!</FONT>
<BR><FONT SIZE=3D2>Matthew</FONT>
</P>
</BODY>
</HTML>
------_=_NextPart_001_01C0182B.FDF468CC--
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.