title: Delete records in axapta very slow
body: <p>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 (<kbd>alt</kbd>+<kbd>f9</kbd>) 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?</p>
  
  <blockquote>
    <p>edit:</p>
  </blockquote>
  
  <p>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.</p>
  
  <p>createRedIdIndex is not activated.</p>
  
  <p>The filter makes use of one column ( employeeID ) in a queryBuildRange.</p>
  
  <p>deleteAction: another table (B) references the id ( indexed ) of the mentioned table (A). A has a deleteAction on B. setting is "cascade" </p>
  
  <p>The two tables are related via id-field.</p>
  
  <p>The relations can be resolved by an index.</p>
  
  <p>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!</p>