We want to populate a DE using AMPscript on a landing page. The script may entire millions of rows during a period of time.
Is there a limit to that amount of rows DE can contain?
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.Sign up to join this community
I remember seeing a Data extension with a billion rows, which leads me to believe there is no relevant technical limit.
The documentation just lists >100million as "extreme". Certainly that is not beneficial to performance, so this is not an encouragement to go crazy. It's possible though.
Something around 10-15 million wouldn't really worry me too much. the limits one reaches more frequently with DEs are less in pure storage, but more in the speed of imports, extracts, sql timeouts or script operations working with the DE. And here you can of course reach limits faster, which is usecase dependent.