Moderator: Lisa Ennis
We currently have 89 million records in our pfm.Entity table. We created a custom field for our closed date, as the standard field, if someone was to accidentally set the order back to "In Progress" and then you Close it, it automatically sets the date back to the current date/time. The custom field built for us by SoftPro is an XML field stored in the pfm.Entity table.
We are having the issue of our closed order reports taking an excessive amount of time to run 45+ minutes, especially if we run a range for a year.
Does SoftPro have any suggestions on archiving process for the pfm.Entity table, indexing, or perhaps create a view, or export the data somehow, to access it from a date/time field, oppose to XML?
Any and all suggestions are most welcome and needed!
Please note that I have looked on this forum for other examples of the pfm.Entity and we are joining to the pf.OrderInfo table and not the pfm.Order table.
Is it an option to use the "FirstClosed" field from the pfm.StatusHistory table? LastClosed in this table could change, but FirstClosed should not.