This is a multi-part message in MIME format.
------=_NextPart_000_0195_01C01830.46584260
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
RE: count() or recordcountI would love to have the answer to the same
question.
DC
-----Original Message-----
From: Kuehn, Matthew [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 06, 2000 17:58
To: '[EMAIL PROTECTED]'
Subject: RE: count() or recordcount
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/[email protected]/
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.
------=_NextPart_000_0195_01C01830.46584260
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>RE: count() or recordcount</TITLE>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.3018.900" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D057252818-06092000>I=20
would love to have the answer to the same question.</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D057252818-06092000></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D057252818-06092000>DC</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D057252818-06092000></SPAN></FONT> </DIV>
<BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">
<DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> Kuehn, Matthew=20
[mailto:[EMAIL PROTECTED]]<BR><B>Sent:</B> Wednesday, =
September 06,=20
2000 17:58<BR><B>To:</B> =
'[EMAIL PROTECTED]'<BR><B>Subject:</B> RE:=20
count() or recordcount<BR><BR></DIV></FONT>
<P><FONT size=3D2>This message is in MIME format. Since your mail =
reader does=20
not understand</FONT> <BR><FONT size=3D2>this format, some or all of =
this=20
message may not be legible.</FONT> </P>
<P><FONT size=3D2>------_=3D_NextPart_001_01C0182B.FDF468CC</FONT> =
<BR><FONT=20
size=3D2>Content-Type: text/plain;</FONT>=20
<BR> <FONT=20
size=3D2>charset=3D"iso-8859-1"</FONT> </P>
<P><FONT size=3D2>Hello!</FONT> </P>
<P><FONT size=3D2>OT: Does anyone know how I can turn off MIME =
formatting when I=20
send these</FONT> <BR><FONT size=3D2>messages? Every preference I =
check says=20
"plain text", but my messages always</FONT> <BR><FONT size=3D2>get =
converted to=20
MIME/HTML when they're sent out to the list.</FONT> <BR><FONT=20
size=3D2>WinNT4/Outlook2K. Reply OTL, THX.</FONT> </P>
<P><FONT size=3D2>>From: "Bud" =
<[EMAIL PROTECTED]></FONT>=20
<BR><FONT size=3D2>>Which is faster? I'm presuming count() or what =
else would=20
it be good for?</FONT> </P>
<P><FONT size=3D2>I thought I'd take a stab at this comparison and see =
what=20
happened for me.</FONT> <BR><FONT size=3D2>All I need to do with this =
query is=20
to output the number of records</FONT> <BR><FONT =
size=3D2>returned.</FONT> </P>
<P><FONT size=3D2>My original query looked like this and took 72ms on=20
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"=20
datasource=3D"#datasource#"></FONT>=20
<BR> <FONT =
size=3D2>SELECT =20
CODE</FONT> <BR> <FONT=20
size=3D2>FROM =
=20
REFERRAL_CODE</FONT> <BR> =
<FONT=20
size=3D2>ORDER BY CODE ASC</FONT> =
<BR><FONT=20
size=3D2></cfquery></FONT> </P>
<P><FONT size=3D2>The new query looks like this and takes 8ms on =
average.</FONT>=20
<BR><FONT size=3D2>The number of records is output as=20
#DBCodes.TotalRecords#.</FONT> </P>
<P><FONT size=3D2><cfquery name=3D"DBCodes"=20
datasource=3D"#datasource#"></FONT>=20
<BR> <FONT =
size=3D2>SELECT =20
Count(*) AS TotalRecords</FONT> =
<BR> =20
<FONT size=3D2>FROM =
=20
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=20
from this list,</FONT> <BR><FONT size=3D2>I've reduced the time this =
particular=20
page takes to load by about 64ms, and</FONT> <BR><FONT size=3D2>since =
the=20
*entire page* takes 320ms to execute on average, that's a =
pretty</FONT>=20
<BR><FONT size=3D2>big savings! I love this place. :-)</FONT> </P>
<P><FONT size=3D2>Thanks all, and keep 'em coming!</FONT> <BR><FONT=20
size=3D2>Matthew</FONT> </P>
<P><FONT size=3D2>------_=3D_NextPart_001_01C0182B.FDF468CC</FONT> =
<BR><FONT=20
size=3D2>Content-Type: text/html;</FONT>=20
<BR> <FONT=20
size=3D2>charset=3D"iso-8859-1"</FONT> <BR><FONT =
size=3D2>Content-Transfer-Encoding:=20
quoted-printable</FONT> </P>
<P><FONT size=3D2><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML =
3.2//EN"></FONT>=20
<BR><FONT size=3D2><HTML></FONT> <BR><FONT =
size=3D2><HEAD></FONT>=20
<BR><FONT size=3D2><META HTTP-EQUIV=3D3D"Content-Type" =
CONTENT=3D3D"text/html;=20
=3D</FONT> <BR><FONT size=3D2>charset=3D3Diso-8859-1"></FONT> =
<BR><FONT=20
size=3D2><META NAME=3D3D"Generator" CONTENT=3D3D"MS Exchange Server =
version=20
=3D</FONT> <BR><FONT size=3D2>5.5.2650.12"></FONT> <BR><FONT=20
size=3D2><TITLE>RE: count() or recordcount</TITLE></FONT> =
<BR><FONT=20
size=3D2></HEAD></FONT> <BR><FONT size=3D2><BODY></FONT> =
</P>
<P><FONT size=3D2><P><FONT =
SIZE=3D3D2>Hello!</FONT></FONT>=20
<BR><FONT size=3D2></P></FONT> </P>
<P><FONT size=3D2><P><FONT SIZE=3D3D2>OT: Does anyone know =
how I can=20
turn off MIME =3D</FONT> <BR><FONT size=3D2>formatting when I send =
these messages?=20
Every preference I check says =3D</FONT> <BR><FONT =
size=3D2>&quot;plain=20
text&quot;, but my messages always get converted to =3D</FONT> =
<BR><FONT=20
size=3D2>MIME/HTML when they're sent out to the list. =
WinNT4/Outlook2K. Reply=20
=3D</FONT> <BR><FONT size=3D2>OTL, THX.</FONT></P></FONT> =
</P>
<P><FONT size=3D2><P><FONT SIZE=3D3D2>&gt;From:=20
&quot;Bud&quot; =3D</FONT> <BR><FONT=20
=
size=3D2>&lt;[EMAIL PROTECTED]&gt;</FONT></FONT>=20
<BR><FONT size=3D2><BR><FONT SIZE=3D3D2>&gt;Which is =
faster? I'm=20
presuming count() or what =3D</FONT> <BR><FONT size=3D2>else would it =
be good=20
for?</FONT></FONT> <BR><FONT size=3D2></P></FONT> </P>
<P><FONT size=3D2><P><FONT SIZE=3D3D2>I thought I'd take a =
stab at=20
this comparison and see =3D</FONT> <BR><FONT size=3D2>what happened =
for=20
me.</FONT></FONT> <BR><FONT size=3D2><BR><FONT =
SIZE=3D3D2>All I=20
need to do with this query is to output the =3D</FONT> <BR><FONT =
size=3D2>number=20
of records returned.</FONT></FONT> <BR><FONT =
size=3D2></P></FONT>=20
</P>
<P><FONT size=3D2><P><FONT SIZE=3D3D2>My original query =
looked like=20
this and took 72ms on =3D</FONT> <BR><FONT =
size=3D2>average.</FONT></FONT>=20
<BR><FONT size=3D2><BR><FONT SIZE=3D3D2>The number of =
records was=20
output as =3D</FONT> <BR><FONT =
size=3D2>#DBCodes.RecordCount#.</FONT></FONT>=20
<BR><FONT size=3D2></P></FONT> </P>
<P><FONT size=3D2><P><FONT SIZE=3D3D2>&lt;cfquery=20
name=3D3D&quot;DBCodes&quot; =3D</FONT> <BR><FONT=20
=
size=3D2>datasource=3D3D&quot;#datasource#&quot;&gt;</FONT=
></FONT>=20
<BR><FONT=20
=
size=3D2><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
;nbsp;&nbsp;=20
<FONT =3D</FONT> <BR><FONT size=3D2>SIZE=3D3D2>SELECT&nbsp;=20
CODE</FONT></FONT> <BR><FONT=20
=
size=3D2><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
;nbsp;&nbsp;=20
<FONT =3D</FONT> <BR><FONT=20
size=3D2>SIZE=3D3D2>FROM&nbsp;&nbsp;&nbsp; =3D</FONT> =
<BR><FONT=20
=
size=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
;nbsp;=20
REFERRAL_CODE</FONT></FONT> <BR><FONT=20
=
size=3D2><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
;nbsp;&nbsp;=20
<FONT SIZE=3D3D2>ORDER BY =3D</FONT> <BR><FONT=20
size=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
CODE=20
ASC</FONT></FONT> <BR><FONT size=3D2><BR><FONT=20
SIZE=3D3D2>&lt;/cfquery&gt;</FONT></FONT> <BR><FONT=20
size=3D2></P></FONT> </P>
<P><FONT size=3D2><P><FONT SIZE=3D3D2>The new query looks =
like this=20
and takes 8ms on =3D</FONT> <BR><FONT =
size=3D2>average.</FONT></FONT>=20
<BR><FONT size=3D2><BR><FONT SIZE=3D3D2>The number of =
records is=20
output as =3D</FONT> <BR><FONT=20
size=3D2>#DBCodes.TotalRecords#.</FONT></FONT> <BR><FONT=20
size=3D2></P></FONT> </P>
<P><FONT size=3D2><P><FONT SIZE=3D3D2>&lt;cfquery=20
name=3D3D&quot;DBCodes&quot; =3D</FONT> <BR><FONT=20
=
size=3D2>datasource=3D3D&quot;#datasource#&quot;&gt;</FONT=
></FONT>=20
<BR><FONT=20
=
size=3D2><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
;nbsp;&nbsp;=20
<FONT =3D</FONT> <BR><FONT size=3D2>SIZE=3D3D2>SELECT&nbsp; =
Count(*) AS=20
TotalRecords</FONT></FONT> <BR><FONT=20
=
size=3D2><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
;nbsp;&nbsp;=20
<FONT =3D</FONT> <BR><FONT=20
size=3D2>SIZE=3D3D2>FROM&nbsp;&nbsp;&nbsp; =3D</FONT> =
<BR><FONT=20
=
size=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
;nbsp;=20
REFERRAL_CODE</FONT></FONT> <BR><FONT =
size=3D2><BR><FONT=20
SIZE=3D3D2>&lt;/cfquery&gt;</FONT></FONT> <BR><FONT=20
size=3D2></P></FONT> </P>
<P><FONT size=3D2><P><FONT SIZE=3D3D2>So, in my case, =
using the tips=20
and techniques I've =3D</FONT> <BR><FONT size=3D2>picked up from this =
list, I've=20
reduced the time this particular page =3D</FONT> <BR><FONT =
size=3D2>takes to load=20
by about 64ms, and since the *entire page* takes 320ms to =3D</FONT> =
<BR><FONT=20
size=3D2>execute on average, that's a pretty big savings! I love this =
place.=20
=3D</FONT> <BR><FONT size=3D2>:-)</FONT></P></FONT> </P>
<P><FONT size=3D2><P><FONT SIZE=3D3D2>Thanks all, and keep =
'em=20
coming!</FONT></FONT> <BR><FONT size=3D2><BR><FONT=20
SIZE=3D3D2>Matthew</FONT></FONT> <BR><FONT =
size=3D2></P></FONT>=20
</P>
<P><FONT size=3D2></BODY></FONT> <BR><FONT =
size=3D2></HTML></FONT>=20
<BR><FONT size=3D2>------_=3D_NextPart_001_01C0182B.FDF468CC--</FONT> =
<BR><FONT=20
=
size=3D2>----------------------------------------------------------------=
--------------</FONT>=20
<BR><FONT size=3D2>Archives: <A=20
href=3D"http://www.mail-archive.com/[email protected]/"=20
=
target=3D_blank>http://www.mail-archive.com/[email protected]/</A=
></FONT>=20
<BR><FONT size=3D2>To Unsubscribe visit <A=20
=
href=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3D=
lists/cf_talk"=20
=
target=3D_blank>http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&am=
p;body=3Dlists/cf_talk</A>=20
or send a message to [EMAIL PROTECTED] with =
'unsubscribe' in=20
the body.</FONT></P></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_0195_01C01830.46584260--
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
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.
