Help needed with Implicit Transactions!

[TinkerToy__]

Hi all:

I am trying to adjust the default isolation level in CFMX 7. See this technote
for CFMX 6:


[url]http://www.macromedia.com/support/coldfusion/releasenotes/mx/releasenotes_mx.htm[/url]
l#perf

To quote:

Macromedia tests indicate that some database-intensive applications can
improve their performance by changing the default Isolation Level of their data
sources from the implicit default setting of READ_COMMITTED to
READ_UNCOMMITTED.
To change this setting, edit the
cf_root\runtime\servers\default\SERVER-INF\jrun-resources.xml file in Windows
or the cf_root/runtime/servers/default/SERVER-INF/jrun-resources.xml file on
UNIX. Add the following line to the definition of your data source (as its own
line):
<isolation-level>READ_UNCOMMITTED</isolation-level>
Note: If you edit your data source definition later using the ColdFusion
Administrator, the definition is saved without the Isolation Level setting; you
must add this value to the jrun-resources.xml file again.
If you do not want to change the isolation level for the entire data source,
you can explicitly set the isolation level for a transaction by specifying the
isolation attribute with the cftransaction tag.

Fine. The only problem is that file exists in a different directory
(cf_root\runtime\servers\coldfusion\SERVER-INF\ ) and there is no reference in
that file to my datasources as I imagine them (i.e. as specified in the
CFAdmin) . So the question I guess is: is this the right file for MX 7?? :)

Thanks
Ciaran.

[TinkerToy__]

Hi all:

I have managed to find a tech note describing how to do this in CFMX 6.1.

[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=5444c687[/url]

I don't think it's the same in CFMX 7. The reason being that they give no
indication of where in the jrun_resources.xml file you put the described lump
of XML and I can't get it to work no matter where I put it in the XML file. Is
there an updated version of this technote for CFMX 7? Can someone please let me
know, one way or the other?

Cheers!
Ciaran.

[TinkerToy__]

Hi, just bumping this up as it's still an issue for me. Can anyone give some advice?

Thanks.

[yalta]

Fine. The only problem is that file exists in a different directory
(cf_root\runtime\servers\coldfusion\SERVER-INF\ ) and there is no reference in
that file to my datasources as I imagine them (i.e. as specified in the
CFAdmin) . So the question I guess is: is this the right file for MX 7??
The difference in naming should be due to the fact that there might be a
separate JRUN installation, so I guess one might have the folder
cf_root\runtime\servers\jrun\SERVER-INF\ or
cf_root\runtime\servers\default\SERVER-INF\ OR
cf_root\runtime\servers\coldfusion\SERVER-INF\ - It's similar to other
differences that occur between installations ... default place for custom tags,
default place for Verity... I know it's not the same reason, but you might well
expect slight changes.

Now for the place to put the datasources - We know from the TechNote that
there are NO datasources anynore in jrun-resources.xml anymore, IF they were
not added there by JRUN admin settings (in case you have a separate JRUN) or by
just editing manually. The datasources are saved - in a different XML style -
in CFROOT/lib/neu_query.xml

The Tech note says you will never see manually added datasources from the
jrun-resources file in the admin interface; that will only show those from the
neo-file. So what you have to do is ...
set up the datasource in the admin interface with a different name, let's say
dsn1_adm
copy the example code from the tech note for a datasource setup in
jrun-resources.xml for your type of database and edit the details, replacing
the defaults with the values from your dsn_adm datasource as they are saved in
neo_query.xml, being sure to pick a different name for the new datasource
(dsn1_jrun)
Test the two datasources with a cfquery, not from the admin interface

Anyway, are you really sure it is worth to do these changes? Uncommitted read
would only make sense if you have a high level of changes, I'd imagine. Usually
it is at different places where you can improve a lot.

[TinkerToy__]

Thanks for that yalta - that's pretty similar to what was described in the tech
note but i'll try it again. I assume the section you paste into the
jrun-resouces.xml file is pasted in under the <jrun-resources> tag? These sort
of specifics would help ! :)

It would be really nice if they would include the isolation level as an
tickable attribute in CF admin :)

Just to let you know - we would like to remove implicit transactions
altogether if possible from al CF-executed queries. Is this possible to do? If
not we are hoping that this change might increase performance and reduce the
number of blocking processes we are experienceing with SQLServer to a mininum.
We are looking at a number of areas - this being one.

Cheers
Ciaran.