I'm not sure how much flexibility I have on this version because it's a hosted solution in a shared environment:
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. The other thing is both CF versions are Standard, not Enterprise, so I'm limited in the use of CFThread, but I did try it anyway :) Thanks Matt On Mon, Oct 31, 2011 at 5:45 PM, Jochem van Dieten <joch...@gmail.com> wrote: > > On Mon, Oct 31, 2011 at 8:56 PM, Matt Blatchley wrote: >> So my question is this: Is it possible to have multiple queues >> running on different machines and dumping the data into the same >> table? > > Yes. > > >> Using cftransaction, the second queue attempts to run but has to wait >> until the main Queue finishes before the secondary queue starts. > > That is probably caused by the exact SQL used in combination with the > locking strategy your database is using. You have to either make sure > your database doesn't use predicate locking, or that you don't run > multi row statements by separating the table that holds the actual > queue from the one where you lock your records in a transaction > > More details on database schema's, vendors and versions will result in > more details in the answer :) > > Jochem > > > -- > Jochem van Dieten > http://jochem.vandieten.net/ > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:348392 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
