We have over 13 million records in our invoice lines table (ACUIVR). COS350 is the program that displays this file. When trying to look up an order by CO number it can literally take several minutes to load facilities with higher numbers. This is both on-prem and cloud. In cloud it times out and never displays. The problem is that it is reading the ACUIVR table as the primary, which doesn't contain facility, and then chaining out to another table to get the facility. This means for our Read more...facility 900, it has to read 13 million records before determining that there are actually no records for facility 900. Development has agreed that this is a problem but requires an enhancement request in order to fix it.
