web stats
Removing Messages: Are deletes committed after each statement, or after the session? - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 04-03-2018, 11:29 AM
martinan martinan is offline
Mirth Newb
 
Join Date: Sep 2015
Posts: 16
martinan is on a distinguished road
Default Removing Messages: Are deletes committed after each statement, or after the session?

We are running a delete (removed messages in the administrator) on a large number of messages in one of our channels, which is taking a long time to complete (more than a day so far). We are running Mirth Connect 3.4.2 with a SQL Server back end, and I wanted to see if anyone knew:

Are these deletes committed after each statement, or after all of the delete statements in the session are completed?

We don't want to kill the process on the back end if SQL Server is going to rollback all of the delete transactions that have occurred in the session.

Here is an example of one of the transactions that we see:

Code:
(@P0 bigint)DELETE FROM D_M13
		WHERE ID =  @P0
I don't see a commit in any of the statements, so I assume that it is committed once the session completes.

Any help would be greatly appreciated.

Thanks,
martinan
Reply With Quote
Reply

Tags
delete message, mirth 3.4.2, sql server

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 03:16 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Mirth Corporation