• Replies 2 replies
  • Subscribers 336 subscribers
  • Views 21 views
  • Users 0 members are here
Related

UP_CLEANUP_EXTRACTIONS

Former Member
Former Member $organization

Has anyone used this? I am finding it is taking an incredibly long time to run. I tried narrowing the dates but it is still taking long. Have you had the same experience?

Parents
  • Former Member
    Former Member $organization

    Thanks Dmitrij,

     

    That sounds like it might take a while as I want to remove about 6 years’ worth. I’m going to look into the BCP option that is described in the docs.

     

    Thanks again,

     

    Gloria

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Dmitrij Zeile
    Sent: Monday, March 03, 2014 12:54 PM
    To: Gloria Ormsby
    Subject: Re: [Tessitura Technical Forum] UP_CLEANUP_EXTRACTIONS

     

    Hi Gloria,

    We did use this, I even recorded some stats:

     

    Rows

    Time

    361335

    00:09:32

    1051477

    00:16:42

    1550936

    00:24:28

    1819043

    00:34:00

    2145401

    00:37:21

    3262336

    00:50:47

    My advice is to create a regular job that deletes lets say 90 days worth of data every day.

    Best regards,

    Dmitrij

     

    From: Gloria Ormsby <bounce-gloriaormsby5026@tessituranetwork.com>
    Sent: 2/28/2014 9:29:44 AM

    Has anyone used this? I am finding it is taking an incredibly long time to run. I tried narrowing the dates but it is still taking long. Have you had the same experience?




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Reply
  • Former Member
    Former Member $organization

    Thanks Dmitrij,

     

    That sounds like it might take a while as I want to remove about 6 years’ worth. I’m going to look into the BCP option that is described in the docs.

     

    Thanks again,

     

    Gloria

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Dmitrij Zeile
    Sent: Monday, March 03, 2014 12:54 PM
    To: Gloria Ormsby
    Subject: Re: [Tessitura Technical Forum] UP_CLEANUP_EXTRACTIONS

     

    Hi Gloria,

    We did use this, I even recorded some stats:

     

    Rows

    Time

    361335

    00:09:32

    1051477

    00:16:42

    1550936

    00:24:28

    1819043

    00:34:00

    2145401

    00:37:21

    3262336

    00:50:47

    My advice is to create a regular job that deletes lets say 90 days worth of data every day.

    Best regards,

    Dmitrij

     

    From: Gloria Ormsby <bounce-gloriaormsby5026@tessituranetwork.com>
    Sent: 2/28/2014 9:29:44 AM

    Has anyone used this? I am finding it is taking an incredibly long time to run. I tried narrowing the dates but it is still taking long. Have you had the same experience?




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Children
No Data