Dear All,
If i insert huge records in table then it will cause of memory consumption?
Please give me more shed on this.
Thanks!
Arpan Sen
*This post is locked for comments
Hi Faisal,
Can you please let me know how i can clear record after insertion.
Arpan
Thanks Vilmos
We have no insight on how AX kernel consumes memory, since we have no source code access to that. There is an internal garbage collector that periodically cleans up memory space used.
These are the publicly available information on the topic:
blogs.msdn.microsoft.com/.../1-the-garbage-collector-in-x-and-the-clr
blogs.msdn.microsoft.com/.../memory-usage-in-xppil-code
Whether your specific code consumes memory or not highly depends on what exactly you have in your code. Temporary tables, objects like Map or Set, or simply reading in large amount of information which can cache table data locally might all bump your memory usage. I'd say it is the table cache without seeing code.
Which memory consumption you are concerning about? Insert_recordset uses record list you can clear after record insertion however it flashes automatically I reckon.
Thanks Faisal,
During inserting time it will make a database call. But after completing inserting operation it will consume memory?
Hi Arpen,
For bulk insert use insert_recordset it will make a database call once led to improve performance.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Andrés Arias as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 2 Most Valuable Professional
Guy Terry 2 Moderator
Mea_ 2
