Have a look at Hal Helms' May newsletter:
http://www.halhelms.com/index.cfm?fuseaction=newsletters.may2001
(The Return of Mr SQL :-))
-Original Message-
From: John Quarto-vonTivadar [mailto:[EMAIL PROTECTED]]
Sent: 29 November 2001 06:20
To: CF-Talk
Subject: brain fart: some simple SQL
?ArticleID=26
Fiona
-Original Message-
From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]]
Sent: 20 November 2001 16:21
To: CF-Talk
Subject: RE: Datediff
Sorry, I meant:
Mike
-Original Message-
From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November
I just ran a quick test:
against
a=1;
b=2;
c=3;
d=4;
The cfscript consistently ran at least 10ms faster than the block
over 1000 iterations
For this comparison:
against
for(a=i;a lte 10;a=a+1)
y=a;
The cfscript ran about 100ms faster for the over 1000 iterations
Both of the
bject: RE:
Actually, if you have a site-wide error handler set in the
administrator, it will be called before the request template
-Original Message-
From: Fiona Barker [mailto:[EMAIL PROTECTED]]
Sent: vrijdag 9 november 2001 10:32
To: CF-Talk
Subject: RE:
In general, it's b
In general, it's best to use exception and request types. The exception type
has a lot more flexibility (eg you can get it to email you directly there is
a problem) and will always execute before the request type. However, if
there is an error in your exception handler, then the request template w
Hi Joy,
Can't give you too many details, because it's quite a time since I used it,
but I once used Crytal Reports for doing something similar, and it was very
successful. Don't get confused with the CF documentation, though, Crytal
Reports is a separate product, it doesn't come bundled with CF,
riginal Message-
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: 02 November 2001 14:33
To: CF-Talk
Subject: RE: Caching Queries
On 11/2/01, Fiona Barker penned:
>If you have a heavy load site, caching a query for 3-4 seconds will improve
>performance without your data being out of date: Person A re
Eric:
there's a couple of articles on allaire.com. Just search for 'query
caching'.
Basically, query caching is a Good Thing, as long as you use it sensibly and
handle it correctly.
A few points to consider:
Query caching only applies to queries of the same name and with the same
(exact same) SQL
8 matches
Mail list logo
