hero."
-Original Message-
From: Joshua Miller [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 16, 2003 5:39 PM
To: CF-Talk
Subject: RE: Macromedia TechNote on Database Performance
But that doesn't work when you do:
Query#ID#.RecordCount
I can get it to generate the query, just not c
EMAIL PROTECTED]
*
-Original Message-
From: paul smith [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 16, 2003 6:02 PM
To: CF-Talk
Subject: RE: Macromedia TechNote on Database Performance
QUERY="MyQuery#ID#"
best, paul
At 05:04 PM 1/16/03 -0500, you wrote:
>I'm having luck jus
QUERY="MyQuery#ID#"
best, paul
At 05:04 PM 1/16/03 -0500, you wrote:
>I'm having luck just changing some queries to Stored Proceedures ... I'd
>like to use caching, but I can't figure out a way to specify dynamic
>query names.
Joshua Miller wrote:
>
> --- "For instance, the SELECT MAX(ID) + 1 -> INSERT trick to get the
> next
> value for a primary key technically requires a serializable isolation
> level."
>
> That seems like a bad idea anyway, wouldn't it be possible for someone
> to write to the database between yo
ECTED]
> ***
> *
> *****
>
>
> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 16, 2003 2:15 PM
> To: CF-Talk
> Subject: RE: Macromedia TechN
immediately and
advise us by return e-mail to [EMAIL PROTECTED]
*
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 16, 2003 5:04 PM
To: CF-Talk
Subject: Re: Macromedia TechNote on Database Performance
Joshua Miller wrote:
> D
us by return e-mail to [EMAIL PROTECTED]
*
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 16, 2003 2:15 PM
To: CF-Talk
Subject: RE: Macromedia TechNote on Database Performance
> Does anyone hav
Joshua Miller wrote:
> Does anyone have any information on changing the Isolation Level on MS
> SQL Server 2000 as referenced in:
> http://www.macromedia.com/support/coldfusion/releasenotes/mx/releasenote
> s_mx.html#perf
>
> Does this have much impact on performance? If so, how do I do it? There
> Does anyone have any information on changing the Isolation Level on MS
> SQL Server 2000 as referenced in:
> http://www.macromedia.com/support/coldfusion/releasenotes/mx/releasenote
> s_mx.html#perf
Everyone, please be very careful about this! You should understand
precisely what the implicatio
> Does anyone have any information on changing the Isolation
> Level on MS SQL Server 2000 as referenced in:
> http://www.macromedia.com/support/coldfusion/releasenotes/mx/r
> eleasenotes_mx.html#perf
>
> Does this have much impact on performance? If so, how do I
> do it? There is no setting in
I think that was actually supposed to be pulled out of the docs. Here's what I was
told regarding that setting: "It turns out that the isolation level gain is nearly
negligible, and can degrade performance in some cases...found after CFMX Server
shipped".
If you did want to try it in your envir
11 matches
Mail list logo