Dynamics Community Forum Thread Details

My PJAllAud table is Ginormous

Aloha,

I was wondering if anyone knows the details behind the PJAllAud (Allocator audit) table. I understand its purpose; what I am specifically interested in is will it continue to grow infinitely or should there be a process that truncates the table that I am not currently doing. I ask because it has become quite large, over 20% of our total application database size and being a clean freak that I am, I like to keep my databases neat and in order.

What would happen if I delete some old records in there that were added when we first went live over 8 years ago?

Mahalo,

-Scott

Aloha right back atcha Scott,

pjallaud is used by allocator during the reallocation process. (Mine has close to 8 million records in it, dating back to 2000, just for comparison purposes.)

Effectively, if you remove records from this table, you won't be able to reallocate the associated transactions.

Additionally, sometimes folks use the pjallaud table as input into reports that trace how an item moved through the database.

Normally, an accounting team isn't going to want to reallocate 8 year old transactions. But they may find themselves needing to understand how those transactions moved from point A to point B.

Personally, I wouldn't remove records from pjallaud unless I was also purging data from that time period across the entire system unless there was some performance problem I was dealing with that could be directly traced to pjallaud.

If I did find it necessary to remove records, I'd make a point of archiving the data in the same structure in a different database on the off chance that I found myself needing it back at some point.

Hope this helps!

Best,

Kiara

Quick Links