Hi 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 |
|
