Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Issue with mrexpfil_sql table

Status
Not open for further replies.
dgillz

dgillz

Instructor
Mar 2, 2001
10,038
US
Macola Progression 7.9.200

So I had a request to write the MRP by Date Report as an Excel Power Query. Looks great and runs in 4 seconds.

UNTIL I decided to add the MRP exception codes. Then the query takes 25 minutes! In either excel or SSMS, it is a dog.

I have checked the indexes, they're good. I've rebuilt the table. It still takes 25 minutes.

Has anyone had issues with this table in queries? Any work arounds?

Macola Software Veteran and SAP Business One Consultant on Training Wheels

Check out our Macola tools:

 
Status
Not open for further replies.

Similar threads

O
  • Locked
  • Question
Flex Issue
Replies
0
Views
205
OrganicByNature
O
prog_0927
  • Locked
  • Question
Journal Source SQL Table
Replies
9
Views
346
dgillz
dgillz
prog_0927
  • Locked
  • Question
Status on APOPNHST_SQL Table
Replies
1
Views
160
dgillz
dgillz
mjbasecamp
  • Locked
  • Question
What is the highest version of SQL Server 2017 CU that Macola Progression 7.9.300 is compatible with
Replies
3
Views
216
dgillz
dgillz
nsiegmundt
  • Locked
  • Question
How to edit the "search_desc" field for an item inside of macola (table imitmidx_sql)
Replies
1
Views
136
dgillz
dgillz

Part and Inventory Search

Sponsor

Back
Top