Re: CFtransaction questions

2011-11-01 Thread Matt Blatchley
> That is what snapshot isolation is designed for: > http://msdn.microsoft.com/en-us/library/tcbchxcb%28v=vs.80%29.aspx Great information, thank you Jochem. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Ado

Re: CFtransaction questions

2011-11-01 Thread Jochem van Dieten
On Tue, Nov 1, 2011 at 1:13 AM, Matt Blatchley wrote: > Microsoft SQL Server 2008 (SP1) > Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2) > > Database table stores the Metrics by daily values so it's constantly > being hit by the imported data and the user interface. That

Re: CFtransaction questions

2011-11-01 Thread Matt Blatchley
Very true. Thanks Russ. ~| 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:

Re: CFtransaction questions

2011-11-01 Thread Russ Michaels
well don;t forget that CF now has debugging again, so you could use cfeclipse to step through and see what is happening. I wouldn't expect 2 concurrent requests to run exactly the same, as presumably each would be working on different data surely ? On Tue, Nov 1, 2011 at 11:22 AM, Matt Blatchley

Re: CFtransaction questions

2011-11-01 Thread Matt Blatchley
I thought that would be the case as well after researching a bit further, but I haven't been able to get the two to finish at the same time. Could just be a timing thing. The code that is executed once the XML response is returned is quite lengthy, performing a number of checks and rolling up th

Re: CFtransaction questions

2011-11-01 Thread Russ Michaels
that really shouldn't cause you to only be able to run 1 request at a time. what actually happens if you run the page twice at the same time ? On Tue, Nov 1, 2011 at 12:39 AM, Matt Blatchley wrote: > > Win2003 Standard > > I removed the cflock and I'm currently using isolation="READ_COMMITTED">

Re: Problem deleting Solr Keys

2011-11-01 Thread Raymond Camden
I'm really at a loss here. It should not be your Java version though. If you restart CF, and then run your delete, does it work? Thinking maybe something is locked. Although I'd imagine you would get an error instead of a silent fail . On Mon, Oct 31, 2011 at 4:55 PM, Dean Lawrence wrote: > > Ye