Delete records in axapta very slow

Question

I've got a form in ax 2009, showing filtered records of a table (about 5.000.000 records total, about 1000 shown filtered). Selecting a couple of those records in the form and deleting them via form-control (alt+f9) is very slow. One record is deleted immediately, selecting about 20 takes several minutes! There is only one deleteAction on the table - any idea what could thwart the operation?

edit:

The regarding table has two indices, both don't allow duplicates. First one is an index on an integer field, second one is a combined one of three fields.

createRedIdIndex is not activated.

The filter makes use of one column ( employeeID ) in a queryBuildRange.

deleteAction: another table (B) references the id ( indexed ) of the mentioned table (A). A has a deleteAction on B. setting is "cascade"

The two tables are related via id-field.

The relations can be resolved by an index.

And it's only an amount of about 20 records I want to delete - so I don't go in line with the idea, that the "to-delete-data-amount" is too big!

Answer 1

Also have a look on this link.

Consider adding

grid.autoSizeColumns(false);

as suggested in the article.

Answer 2

Use the code profiler to see where the time is used.

Answer 3

Do diagnose database performance issues in AX, enable SQL tracing in Tools\Setup in the SQL tab page.