PDA

View Full Version : Deleting items


safl
11-01-2006, 12:38
Hello!

I am having performance hits when deleting items, since the delete_item also deletes the entire history+trends for the given item.

I'f i remove the function calls to delete_history and delete_trends. Will the History + trends be deleted on housekeeping? Since i only keep one day of history i can live with having deprecated data until housekeeping starts.
Or is there a better workaround?

Since this would speed up several procedures i am very interested in the answer.

Regards,
Simon

Alexei
11-01-2006, 12:51
I'm improving housekeeping to deal with such situations soon. No item history data will be removed immediately.

safl
11-01-2006, 13:53
Sounds great!
Any idea as of when it will be available?

Could it be expanded like this:

If an item is deleted include an option of not deleting any history / trends. So if the item is added again one would still have all of the old history / trends? Or is this a sidestep? I guess it could potentially fill up the DB with unused data.