Easy to Create, Easy to Change - Easy to use!


Frequent Deletion


Started by Jeyarajah Arulrajah
Search
You will need to Sign In to be able to add or comment on the forum!

Frequent Deletion

I have seen in the previous versions, meaning before 8. Where deleting records in a table frequently makes that table become inconsistent. 

All I do is something like this:

delete records in Holding with (CurrUser = current user name) .

It looks like this is happening in DE8.2 also, not confirmed yet. But, I have a feeling this is what causing some reorg issue.

Have you seen or heard similar issue in 8.2?

Written by Jeyarajah Arulrajah 13/10/14 at 14:52:44

Re:Frequent Deletion

The problem is "delete records in"....

It is on our fix list but so far we haven't gotten to it.

delete records (without in) is very efficient because it simply truncate the table, but "delete records in" is a very inefficient function.

For some reason it doesn't use indexes and it delete records in single steps, so based on the amount of traffic one "delete records in" cause it is not surprising that it cause inconsistency frequently.

We know that it was very "popular" to use this method in DFW 5.x and 6.x but I think a re-visit of why this was done will reduce the instances a lot.

If one need to use temporary tables in a multi-user environment it is better to have a number of tables and employ your own locking system for them i.e. a table where you store if that table is currently in use etc.

It is a little more work than using delete records in but it will be a 100 times more efficient and you will get rid of all the inconsistency problems. 

Written by DataEase 13/10/14 at 18:33:42

Re:Re:Frequent Deletion

This worked fine in one of the older versions, I can't remember which one. I think DE6.1. 

Anyways, I use this to manipulate data before printing a report. This helps a lot with recreating layout when we make a change in the script. But, I guess this goes away with DE8.2 where we can keep the layout. Also if we need to do multiple grouping, temporary table helps a lot.

Written by Jeyarajah Arulrajah 14/10/14 at 13:10:01