The calculations for all cogs and fedex times get to be slow > 2M records in the DB. These stats need to be available, but prob not upoon every load of this view. The stats could be in a reports section which are refreshed periodically. These stats could be limited to calculating on the past 'n' records, or since some date.
The calculations for all cogs and fedex times get to be slow > 2M records in the DB. These stats need to be available, but prob not upoon every load of this view. The stats could be in a reports section which are refreshed periodically. These stats could be limited to calculating on the past 'n' records, or since some date.