Issue

With a large data set the Work

Solution or Workaround

PTR 91626 has been resolved in Pro 2011

Order Transaction report can be extremely slow.

Steps to Duplicate

With a large data set the Work Order Transaction report can be extremely slow.
Additional Information
———————-
Works fine in a database with little data. Here’s their stats:
WOMAST Record Count = 4,546
WOTRAN Record Count = 26,317
WODWIP Record Count = 48,338 (Not sure if this table is used in the report or not)
SQL Trace shows the temp table the report generates included every WO and then goes through order by order and deletes the records not in the filter. This appears to be what makes it slow.
======================================================================
My tests with large WO data set took almost 24 hours to complete.
WOMAST = 30359
WOTRAN = 728971
WODWIP = 629286