Regarding wkDlv_..............Tables | Community
Skip to main content
S
Shruti1
Level 4
October 6, 2022
Solved

Regarding wkDlv_..............Tables

  • October 6, 2022
  • 1 reply
  • 1683 views

 please let me know

when these tables are created wkDlv_447220343 We can see there are are so many tables exist in pour db which starts with namespace......"wkDlv And the count of these tables in our db is close to 3000 and it is now affecting db performance can u please tell us when those tables are created, can we delete them from db manaully

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by costa_n11

HI @shruti1 

These tables are created as part of workflow and delivery execution, they hold the target audience for that particular delivery.

We are back to the fact that you keep the interim results in your workflow and these tables won't be purged by the standard cleanup process.

Please do apply best practices to NOT use the "keep interim results" and "SQL Logs" options selected if you want to have a stable database.

Right now your solution will become more and more unstable because these options being selected across all your workflows, your database is never purged, keeping these options selected won't help the system getting better.

Thanks

Denis

1 reply

C
Adobe Employee
costa_n11Adobe EmployeeAccepted solution
Adobe Employee
October 6, 2022

HI @shruti1 

These tables are created as part of workflow and delivery execution, they hold the target audience for that particular delivery.

We are back to the fact that you keep the interim results in your workflow and these tables won't be purged by the standard cleanup process.

Please do apply best practices to NOT use the "keep interim results" and "SQL Logs" options selected if you want to have a stable database.

Right now your solution will become more and more unstable because these options being selected across all your workflows, your database is never purged, keeping these options selected won't help the system getting better.

Thanks

Denis

    S
    Shruti1Author
    Level 4
    October 10, 2022

    @costa_n11 

     

    please recomemnd:

    We have close to 2000 OLD wkfs LAST PROCESSED ON 2019 where  "kEep interim result ..." is checked 

    now coz of this lot of temp tables were created and right now also they exist in db

    now wwe want those tables to deleted from db====

    we are thinking to follow this approach as recommeded by one of our colleegue":

    Could you please suggest if this approach is safe in this case:

     

    1. Uncheck interim result workflows, purge history and manually execute the cleanup workflow. We saw in the backend database that it deletes the data without manual intervention.

    S
    Shruti1Author
    Level 4
    October 11, 2022

    @costa_n11 

    PLEASE REply

    please

    Terms & ConditionsAccessibility statement

    Loading footer...