Skip to Main Content
Bulk Materials Ideas

Idea and discussion portal for the bulk materials product line. Users may submit, view and vote on ideas submitted by all users.

Status Reviewing
Categories Dispatch
Created by Richard Clemens
Created on Apr 25, 2019

Develop process to purge old data from the AptruckGeopos table

We discovered a SQL statement in Apex that would peg our Database Server and result in very poor performance throughout the Apex system.  Our table at the time had some 2 million + rows.   After working with support and Chris Miranti, we ended up purging the data from this table.   Apex needs to develop a process that will keep this table house-cleaned of old/unused records.   At this point, we are not sure what this table does or how Apex uses it.

  • Attach files