Share
ReportHi Folks,
I have some tables where records are crossing over 7 million. I cannot delete any of these records & currently have no data warehousing in place.
Please suggest
1.What is the max number of records Ax table can handle before it starts impacting performance.
2.Considering i cannot delete any record, should the best alternative way be to introduce data warehousing & move older data to other db periodically, if so then how user will access thsi old data in Ax once moved to data warehousing db.
3.I could only find 1 out of box clean up job, please let me know if there are any out of box cleaning job for list below
| TableName | RowCount | Out of box cleanup available | Out of box job name |
| [dbo].[WORKFLOWTRACKINGARGUMENTTABLE] | 7 millon plus | Could not find | |
| [dbo].[WORKFLOWTRACKINGCOMMENTTABLE] | 7 millon plus | Could not find | |
| [dbo].[WORKFLOWTRACKINGTABLE] | 7 millon plus | Could not find | |
| [dbo].[GENERALJOURNALACCOUNTENTRY] | 5 millon plus | Could not find | |
| [dbo].[EVENTCUD] | 5 millon plus | Could not find | |
| [dbo].[EVENTINBOXDATA] | 4 millon plus | Could not find | |
| [dbo].[EVENTINBOX] | 4 millon plus | Yes | Notification cleanup |
| [dbo].[VENDSETTLEMENT] | 4 millon plus | Could not find | |
| [dbo].[VENDTRANS] | 4 millon plus | Could not find |
All responses (
Answers (
22,350
