Skip to main content
Merged

Deleting multiple rows as a set

Related products:Windows GUIUniversal GUI
  • January 10, 2020
  • 7 replies
  • 191 views

K.Bakkenes
Captain

The GUI supports multiselect deletion of rows for a while now. The default GUI functionality that deletes multiple rows performs too slow and even slower than a task that does the same delete actions.

Selecting all rows in a grid (more than 100) and starting the delete function takes a lot of time to ‘prepare’ the delete. Eventually a pop-up is shown with a confirmation message. Answering the confirmation message with ‘yes’ will start deleting the selected rows. The actual deletion process also takes too much time. Triggers play a role in this too.

We would like to use the default GUI delete function as a set (just as SQL prefers) instead of row for row deletion. The Software Factory could have a checkbox for it in the ‘Subjects’ screen that is called something like ‘Multi-row deletion’.

Did this topic help you find an answer to your question?

7 replies

Forum|alt.badge.img+15
  • Superhero
  • 196 replies
  • January 10, 2020

A small work-around can be achieved using multirow task execution (https://community.thinkwisesoftware.com/blogs-21/multirow-task-execution-159), for the time being. Please note that when applying this approach, it's difficult to explain to an end user that they should use the task in stead of the default ‘delete’ button (I can't explain it to non IT-users...)

But indeed it's very very slow.

This is also a bit similar to the opposite, inserting large sets of data, discussed over here: https://community.thinkwisesoftware.com/development-13/bulk-import-csv-excel-data-858

Both deleting and inserting (import) are not using the advantages of set based operations.


K.Bakkenes
Captain
Forum|alt.badge.img+9
  • Author
  • Captain
  • 41 replies
  • January 10, 2020

Hi René,

a developer is implementing the multirow task execution as we speak.It works really well but is indeed difficult to explain to end users. In this case all other screens use the default delete function and this particular screen needs/gets a task.

Maybe the task could replace the default delete function without showing the task button? Or the task could start when pressing ‘CTRL + -’...


Jasper
Superhero
  • 678 replies
  • January 16, 2020

Linking tasks to C(R)UD actions to execute a task when clicking the Insert/Copy, Update or Delete button is a feature that is already on our (Indicium) backlog, and I like the idea to be able to use multirow tasks too. 

Regarding the performance of the current batch delete: the user interface will first check if all rows are unmodified (using a select statement) before showing the confirmation dialog. When deleting, the layout procedure is executed first to check whether it is allowed to delete the row. This should only take milliseconds per row, however.

Does the debug screen give an indication of what the delay is causing?

 


Mark Jongeling
Administrator
Forum|alt.badge.img+23
Updated idea status OpenNeeds feedback

Jeroen van den Belt
Administrator
Forum|alt.badge.img+9

Hi @K.Bakkenes,

We would still like to hear your input on the last question Jasper asked. Thanks in advance!​​​​​​


Forum|alt.badge.img+15
  • Superhero
  • 196 replies
  • May 5, 2021

Maybe this could be solved by combining

Jop ter Horst

 

with 

?

Although it doesn't solve set based imports, which we would like to have.


Mark Jongeling
Administrator
Forum|alt.badge.img+23
Updated idea statusNeeds feedbackDuplicate
Idea merged into:
Jop ter Horst

All the votes from this idea have been transferred.

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings