Re: Commons Logging issues
On Thu, Sep 29, 2011 at 6:25 PM, Paul Giesenhagen p...@quilldesign.com wrote: SO there was a directory that had the commons logging files in it .. removed those - restarted the CF Service and still have the same error - so at this time, it I believe is just loading the CF defaults. Do you have a piece of code that demonstrates the problem ? -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347841 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: MyFax and CFMail
Make sure there are is no white space in your text email (cfmail from=... to=.../cfmail). -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347842 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Commons Logging issues
First we're loading up the latest batik files.. Then the second cfscript bombs out on the transcoder.transcode(input,output); with the duplicate commons.logging.Log error. It seems to not like the /pdf-transcoder.jar - which is the file that converts from SVG to PDF cfscript batik_paths = [ ExpandPath(/store/batik/lib/batik-ext.jar), ExpandPath(/store/batik/lib/batik-dom.jar), ExpandPath(/store/batik/lib/batik-bridge.jar), ExpandPath(/store/batik/lib/batik-css.jar), ExpandPath(/store/batik/lib/batik-gvt.jar), ExpandPath(/store/batik/lib/batik-util.jar), ExpandPath(/store/batik/lib/batik-svg-dom.jar), ExpandPath(/store/batik/lib/batik-parser.jar), ExpandPath(/store/batik/lib/xml-apis-ext.jar), ExpandPath(/store/batik/lib/xml-apis-ext.jar), ExpandPath(/store/batik/lib/xerces_2_5_0.jar), ExpandPath(/store/batik/lib/batik-xml.jar), ExpandPath(/store/batik/lib/batik-anim.jar), ExpandPath(/store/batik/lib/batik-script.jar), ExpandPath(/store/batik/lib/batik-awt-util.jar), ExpandPath(/store/batik/lib/batik-codec.jar), ExpandPath(/store/batik/lib/batik-transcoder.jar), ExpandPath(/store/batik/lib/pdf-transcoder.jar) ]; application.loader = createObject(component, store.javaloader.JavaLoader).init(batik_paths); /cfscript cfscript transcoder = application.loader.create(org.apache.fop.svg.PDFTranscoder); inputStream = application.loader.create(java.io.StringBufferInputStream).init(svg); input = application.loader.create(org.apache.batik.transcoder.TranscoderInput).init(inputStream); outputStream = application.loader.create(java.io.FileOutputStream).init(pdfPath); output = application.loader.create(org.apache.batik.transcoder.TranscoderOutput).init(outputStream); transcoder.transcode(input, output); outputStream.flush(); outputStream.close(); /cfscript On Thu, Sep 29, 2011 at 6:25 PM, Paul Giesenhagen p...@quilldesign.com wrote: SO there was a directory that had the commons logging files in it .. removed those - restarted the CF Service and still have the same error - so at this time, it I believe is just loading the CF defaults. Do you have a piece of code that demonstrates the problem ? -- ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347843 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Commons Logging issues
Delete org\apache\commons\logging from pdf-transcoder.jar, download the newest common logging jar file from http://commons.apache.org/logging/ and load that with JavaLoader. -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347844 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Commons Logging issues
Mack, Gave that a shot and removed all of the files and directories from the .jar .. uploaded it ... loaded the logger with Javaloader and still not firing - now it's just throwing a 500 error that I can't see .. generic. If I comment out the transcoder.transcode(input,output) I don't get the error. Paul -Original Message- From: Mack [mailto:mrsmith.w...@gmail.com] Sent: Friday, September 30, 2011 9:00 AM To: cf-talk Subject: Re: Commons Logging issues Delete org\apache\commons\logging from pdf-transcoder.jar, download the newest common logging jar file from http://commons.apache.org/logging/ and load that with JavaLoader. -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347845 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Commons Logging issues
Paul, Do you have access to CF's logs ? You should see something in the exception.log ... -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347846 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Commons Logging issues
are you not able to use the Batik classes that come with CF rather than loading your own ? On Fri, Sep 30, 2011 at 4:03 PM, Mack mrsmith.w...@gmail.com wrote: Paul, Do you have access to CF's logs ? You should see something in the exception.log ... -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347847 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Commons Logging issues
- Gaining access to the log files now - No, the ones that come with CF are outdated ... (per my developer). -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Friday, September 30, 2011 10:27 AM To: cf-talk Subject: Re: Commons Logging issues are you not able to use the Batik classes that come with CF rather than loading your own ? On Fri, Sep 30, 2011 at 4:03 PM, Mack mrsmith.w...@gmail.com wrote: Paul, Do you have access to CF's logs ? You should see something in the exception.log ... -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347848 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Commons Logging issues
how about just replacing the Batik files that comes with CF with the newer ones, or removing the ones from CF so they don't conflict with yours ? On Fri, Sep 30, 2011 at 4:30 PM, Paul Giesenhagen p...@quilldesign.com wrote: - Gaining access to the log files now - No, the ones that come with CF are outdated ... (per my developer). -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Friday, September 30, 2011 10:27 AM To: cf-talk Subject: Re: Commons Logging issues are you not able to use the Batik classes that come with CF rather than loading your own ? On Fri, Sep 30, 2011 at 4:03 PM, Mack mrsmith.w...@gmail.com wrote: Paul, Do you have access to CF's logs ? You should see something in the exception.log ... -- Mack ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347849 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion Hosting
If it matters MaxI'd say Viviotech is as good or better than HostMySite ever was...and I was pretty happy when we found HostMySite (the early days) I'm not familiar with Linode On Thu, 2011-09-29 at 22:26 -0400, Max Hamby wrote: I had stayed with hosting.com out of convenience I knew I was paying a premium but everything is tuned just right so I've left it alone. I guess I should have known it was coming. I'm looking pretty hard at Viviotech now (thanks for the recommendation). I'm also considering Linode. ~Max On Thu, Sep 29, 2011 at 8:56 PM, Bryan Stevenson br...@electricedgesystems.com wrote: Max they pulled the same BS on us in the springwe moved to Jordan at Viviotech and are SUPER pleased with them to date. After the hostmysite/host.com mergerthe goodness of hostmysite was swallowed by the badness of hosting.comit was painfully obvious and truly amazing how quickly an excellent organization can go to hell...sad really On Thu, 2011-09-29 at 16:48 -0400, Max Hamby wrote: They aren't going out of the CF hosting business. They are discontinuing their Windows VPS CF Builder product offering (I got the notifications last night as well). Personally, I'm not very happy with the short notice of the termination. If you're not able to meet a short time frame (IMO) for moving your domains/sites, they'll jack the price up by 300% per quarter. They say that they have made this decision after months of analysis... I just wish they would have given a little more of a heads up that they were looking at this. I'm already slammed and didn't need this bombshell dropped on me! Although HMS/Hosting.com has been very reliable for me, I am currently looking at other options due to this notification and the pricing on their available products. ~Max On Thu, Sep 29, 2011 at 1:48 PM, Dean Lawrence dean...@gmail.com wrote: Paul, do you mean GoDaddy.com? I hadn't heard anything regarding hosting.com discontinuing ColdFusion hosting. I just checked their site and they still have it listed. Thanks, Dean On Thu, Sep 29, 2011 at 10:13 AM, Paul Smith psmit...@gmail.com wrote: Yesterday, hosting.com informs me they are going out of the ColdFusion hosting business. This thread has been very useful. Thank you all. I've been with ColdFusion from the VERY beginning and am too old to change now. AHPhostng.net's ColdFusion VPS for $99 looks good to me, but I wonder if there have been any developments since this thread was last posted on. best, paul Can anyone recommend a decent yet cheap web host for ColdFusion? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347850 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion Hosting
things do seem to have gone downhill since hosting.com took over HostMySite, I see customers flying the coop every week it seems. I hear nothing but good things about EdgeWebHosting - http://www.edgewebhosting.net/ If we get customers looking for USA hosting, that is where we send them. -- Russ Michaels www.bluethunderinternet.com : Business hosting services solutions www.cfmldeveloper.com : ColdFusion developer community www.michaels.me.uk : my blog www.cfsearch.com : ColdFusion search engine sky ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347851 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion Hosting
Linode.com is absolutely kickass... but. It's all linux, all the time. You get a slew of different distributions to choose from, and several kernels. You, however, will be responsible for system setup and maintenance. Now, on the positive side of that, the prices are great. You get a ton of bandwidth, a fair amount of disk, and a ton of free rein. I switched to linode in 2009 and never looked back, but I'm a bit more nutty then most ;). -- Matthew Williams Geodesic GraFX www.geodesicgrafx.com/blog twitter.com/ophbalance ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347852 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF and Word.Application
I have found the word.application *extremely* slow when adding rows to a table and populating the cells with data. Has anyone else found this and know of anyway to speed it up? it is taking up to 5 minutes just to write about 50 rows! thanks Hi does anyone know of any good examples on writing/editing text in a word document using application.word COM. I am using the MSDN library but tearing my hair out just trying to add new sentences and replace text. Thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347853 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion Hosting
Thanks MattI'm on Ubuntu, so Linux is not lost on me ;-) On Fri, 2011-09-30 at 12:32 -0400, Matthew Williams wrote: Linode.com is absolutely kickass... but. It's all linux, all the time. You get a slew of different distributions to choose from, and several kernels. You, however, will be responsible for system setup and maintenance. Now, on the positive side of that, the prices are great. You get a ton of bandwidth, a fair amount of disk, and a ton of free rein. I switched to linode in 2009 and never looked back, but I'm a bit more nutty then most ;). -- Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: br...@electricedgesystems.com web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. Please consider the environment before printing this e-mail ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347854 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion Hosting
First off, my mandatory +1 godzillion for Viviotech.net One of the best companies I have ever dealt with and the best hosting company. You, however, will be responsible for system setup and maintenance. The one thing that sold me on Viviotech.net was that the VPS I got was managed. They set it up, locked it down for me. I am a scared to death of being hacked. I love Linux but I just don't know enough about the security end to be comfortable with hardening a Linux machine myself. The other part that sold me was the customer care and response time. They resolved the two minor issues I had in my two years with them in a matter of minutes, not hours. My $0.02 and worth every penny. HTH G! On Fri, Sep 30, 2011 at 12:32 PM, Matthew Williams mai...@geodesicgrafx.com wrote: Linode.com is absolutely kickass... but. It's all linux, all the time. You get a slew of different distributions to choose from, and several kernels. You, however, will be responsible for system setup and maintenance. Now, on the positive side of that, the prices are great. You get a ton of bandwidth, a fair amount of disk, and a ton of free rein. I switched to linode in 2009 and never looked back, but I'm a bit more nutty then most ;). -- Matthew Williams Geodesic GraFX www.geodesicgrafx.com/blog twitter.com/ophbalance ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347855 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
PDF in web.xml question
I use ColdFusion to run security for my site. I put the html and htm in the web.xml file so that it runs through ColdFusion but when I added pdf files, it doesn't work. The .cfm, .htm files in that directory get blocked by security but the .pdf came right up. Anyone else ever run into this? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347856 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
creating a signable PDF...CF9
Does anyone know how to create a signable PDF? We have a need to be ale to create pdf's in CF on the fly, but then they need to be signable via a signing pad (like the one you use for credit card signatures). Does anyone know if this is possible and if so, how do you do it? Thanks! Eric ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347857 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: creating a signable PDF...CF9
On Fri, Sep 30, 2011 at 4:58 PM, Eric Roberts ow...@threeravensconsulting.com wrote: Does anyone know how to create a signable PDF? We have a need to be ale to create pdf's in CF on the fly, but then they need to be signable via a signing pad (like the one you use for credit card signatures). Does anyone know if this is possible and if so, how do you do it? Docusign allows for online PDF signing. So does Agreensign. I've implemented something like this using CF and Docusign. These may provide a solution for you. I think Docusign costs more. Good luck! Stephen ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347858 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
SOT: READ UNCOMMITTED
We have a fairly high-traffic ACF 8 site where SQL Server database gets hit with two types of queries: type 1 - about 1-5 SELECTS per second that have to run as fast as possible *always* ( 1 second) type 2 - about 100-500 other queries per day that are allowed to run slower (5-20 seconds). (These are reports, automated processes, etc.) I know I can declare SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED on some of those type 2 queries so that they do not issue locks on tables that type 1 requires to do its thing. My question is: if the goal is to make sure type 1 remains as fast as possible, will it help/hurt to also declare SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED on type 1 queries? -- John Bliss - http://about.me/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347859 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
(ot) Awesome Eclipse Shortcut
I know its OT, and most of you probably already know it, but this shortcut saves me so much time, and I'm such a geek, that I had to post it: CTRL + SHIFT + R - then hit Enter Type a few characters of the name of the file your looking for, boom, hit enter to open it. Or if you highlight the name of a component or an include in your code (assuming the filename is similar or the same) and hit the shortcut it will select that file by default. Awesome to find that CFC or include that is buried deep somewhere.. Saves me so much time. Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347860 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) Awesome Eclipse Shortcut
Yeah, that is a sweet one. Even though I've known about it for a while, I am still in the process of training myself to use it, rather than using the Navigation pane to dig into the file tree. My first instinct is always to navigate when looking for a file. -- Josh On Fri, Sep 30, 2011 at 2:55 PM, Brook Davies cft...@logiforms.com wrote: I know its OT, and most of you probably already know it, but this shortcut saves me so much time, and I'm such a geek, that I had to post it: CTRL + SHIFT + R - then hit Enter Type a few characters of the name of the file your looking for, boom, hit enter to open it. Or if you highlight the name of a component or an include in your code (assuming the filename is similar or the same) and hit the shortcut it will select that file by default. Awesome to find that CFC or include that is buried deep somewhere.. Saves me so much time. Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347861 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SOT: READ UNCOMMITTED
I recommend doing this as an optimization technique, as long as you are aware of the tradeoff you are making. The default database settings are optimized for ACID transactional safety, but most Web sites don't need this level of safety unless you are handing financial transactions. Most of the NoSQL databases that are gaining popularity do away with this excessive locking for the benefit of substantial speed increases. In SQL Server establishing and checking locks are a significant percentage of the query time for fast queries, and there is always the risk of deadlocks or lock timeouts. Disabling the locking can have some problems in SQL Server. On very rare occasions you will have one row appear twice in a result set or a row will be skipped, in addition to the obvious issue when you are reading data that is being updated at the same time. These downsides are well documented. The duplicate rows in the result set issue is one most people don't know about. I think Itzik Ben-Gan has written about this problem in detail. Look into the WITH (NOLOCK) query hint. I use WITH (NOLOCK) more frequently than changing the entire transaction to be read uncommitted because you can be more precise with it. For example, not establishing locks on static lookup tables that are involved in a join, but maintaining locks on the transactional tables. If your fast select statements are reading from tables that are never updated, then checking for locks on those tables is wasted overhead. Another related tip is that in the SQL Server Management Studio options, consider changing the default query execution to be read-uncommitted and the deadlock priority to be low. These settings help when you want to jump onto the production server to run a select statement without having much locking impact on the production database. -Mike Chabot http://www.linkedin.com/in/chabot On Fri, Sep 30, 2011 at 5:45 PM, John M Bliss bliss.j...@gmail.com wrote: We have a fairly high-traffic ACF 8 site where SQL Server database gets hit with two types of queries: type 1 - about 1-5 SELECTS per second that have to run as fast as possible *always* ( 1 second) type 2 - about 100-500 other queries per day that are allowed to run slower (5-20 seconds). (These are reports, automated processes, etc.) I know I can declare SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED on some of those type 2 queries so that they do not issue locks on tables that type 1 requires to do its thing. My question is: if the goal is to make sure type 1 remains as fast as possible, will it help/hurt to also declare SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED on type 1 queries? -- John Bliss - http://about.me/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347862 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
