Deleting the contents of a table...fast! - Forum - OpenEdge General - Progress Community

Deleting the contents of a table...fast!

 Forum

Deleting the contents of a table...fast!

  • Maybe its like tribbles ... give them too much room and they just reproduce and fill the available space.

    Consulting in Model-Based Development, Transformation, and Object-Oriented Best Practice  http://www.cintegrity.com

  • After so many years I can confirm that in 11.5 4GL Fast table deletion is implemented ( actually in 11.4 but I do not have it to test). So when a table with one million records takes 2.5 minutes to drop in 10.2B. On the same server in 11.5 one million record table was dropped in 1 second ( same as empty table ). The table has to be in SAT 2 of course. But the indexes do not have to be in SAT 2.

    Dmitri Levin

    Alphabroder

  • you use this feature by deleting a table in the 4GL data dictionary tool.

    note that this works for tables and indexes in type ii data areas but not for type i.

    > On Nov 13, 2015, at 9:50 PM, Dmitri Levin wrote:

    >

    > Update from Progress Community [https://community.progress.com/]

    >

    > Dmitri Levin [https://community.progress.com/members/broder]

    >

    > After so many years I can confirm that in 11.5 Fast table deletion is implemented ( actually in 11.4 but I do not have it to test). So when a table with one million records takes 2.5 minutes to drop in 10.2B. On the same server in 11.5 one million record table was dropped in 1 second ( same as empty table ).

    >

    > View online [https://community.progress.com/community_groups/openedge_general/f/26/p/8292/75199#75199]

    >

    > You received this notification because you subscribed to the forum. To unsubscribe from only this thread, go here [https://community.progress.com/community_groups/openedge_general/f/26/t/8292/mute].

    >

    > Flag [https://community.progress.com/community_groups/openedge_general/f/26/p/8292/75199?AbuseContentId=ef3243fa-583f-46a2-b3fa-a34bfc72f26c&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true] this post as spam/abuse.

  • > After so many years I can confirm that in 11.5 4GL Fast table deletion is implemented ( actually in 11.4 but I do not have it to test).

    I have Progress V11.4 and can confirm that the fast table deletion is working there.

    > The table has to be in SAT 2 of course.

    No matter how large is the table - Progress will delete its contents generating just 9 recovery notes:

    RL_RMDEL

    RL_RMCR

    RL_BKBBOT

    RL_BKMBOT

    RL_BK2EB

    RL_CLUSTER_OWNER

    RL_BKMBOT

    RL_BKFAM

    RL_OLIST_DEL

    > But the indexes do not have to be in SAT 2.

    This is not exactly correct.

    If the indexes are in SAT2 then Progress will use the fast object deletion.

    If the indexes are in SAT1 then Progress will delete the indexes block by block - generating 3 recovery notes per each index block:

    RL_IXDBLK

    RL_BKFAB

    RL_BKFAM

    It's fast but not instant.

  • Thanks for correction. I guess my test with one million records in sports2000 was not enough to see the difference of slow index deletion. Nobody should have anything in SAT I any way (other then a schema).

    Dmitri Levin

    Alphabroder

  • I used this last week to delete a multi-GB table from a test DB.  It was in 11.3, if I recall correctly.  It works great.