What happens on Delete Link/Object

[ColruytTeam]

Hi Community,

Can any one tell me what happens when we delete an object or link? When it will go to database? Immediatly after deleting the object or only on dispatch? is it written to transaction file?

What are the things that makes object/link deletion slow?

Thanks and Regards,

[jhorber]

Colruyt Team

It could be related to technical infrastructure (slow performances) or to metamodel complexity (if the initial deletion triggers multiple deletion in cascade mode).

If you consider you are not in this situation and you can demonstrate that the deletion of a single object takes several minutes, please open a case so that we can perform further investigations.

[ColruytTeam]

Hi Jerome,

Thanks for reply. We are using V1R2 Windows front end private workspace. we didn't implemented public workspace yet.

The objects deletion is taking more than ten minutes some times. Can this be solved? Please let me know how we can go ahead.

Deleting history is not solution that suits for us, as we are using history for some good reason.

Thanks for your help.

[jhorber]

Hello Colruyt Team 

With RDBMS storage, this is not transaction file: updates are performed direclty in the 'database'.

The behavior varies according to the type of workspace used

With public workspace (Web Front-End), updates are made public

• When clicking duplicity on the button 'Save'
• When the system triggers it automatically (auto save feature)
• When switching to another web desktop
• When performing a logout and saving

With private workspace (Windows or Web Front-End), updates are made public

• When clicking explicitly on the button 'Dispatch'
• When performing a logout and dispatching

Private workspaces were previously called 'transactions'.

Deletion of object from the user interface usually takes time as it is a complex processing

• Control of concurrency locks
• Control of permissions
• Cascade deletion...

Deletion of a collection of object can therefore be time consuming