The default isolation level for CFMX7 after applying the client variable patch is "serializeable". Macromedia expresses that serializeable transactions are not optimal for data access (see <cftransaction>) yet that is the new default. Read Macromedia's text on the subject:
"serializable: places an exclusive lock on every data table in use for the duration of the transaction. Causes access to the database to be single-threaded and is therefore not recommended for normal database access." Prior to the client variable fix, the default was "read-committed". Can I reset a datasource to be "read_committed" (via neo-query.xml or otherwise) or is my only option to wrap each query in a <cftransaction> and punt. I have added neo-query.xml to the connectionprops element the following: <var name='ISOLATION-LEVEL'><string>READ_COMMITTED</string></var> ....to no avail. Is there a workaround for MX7? I will be greatly appreciative for a reply. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219530 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
