Results 1 to 3 of 3

Thread: transaction and performance

  1. 04-04-2006, 12:01 PM #1
    cmorel
    cmorel is offline Registered User
    Join Date
    Apr 2006
    Location
    Paris
    Posts
    7

    transaction and performance

    hi guys,

    I have a stupid question:

    I want to use transaction in a stored procedure which is extracting data from a ERP software system and writes to a compression table. The reason for this is making sure that the data in the compression table is not inconsistent if the stored procedure fails.

    Depending on the volume of data, the extraction can take quite some time (20 minutes).

    Are transaction going to alter in any way the performance of the ERP software system?

    Thanks a lot,
    Reply With Quote Reply With Quote
  2. 04-04-2006, 02:03 PM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    need more details
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  3. 04-04-2006, 03:31 PM #3
    nosepicker
    nosepicker is offline Registered User
    Join Date
    Dec 2004
    Posts
    502
    If I understand your question correctly, the answer is no.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules