Is there/what is a Row Limit on UD Tables?
I’m looking to import historical data into a UD table and wanted to see if there was a max on the number of records on a table.
I don’t think so, but I’m assuming…
1 Like
SQL Server doesn’t have a row limit. There might be practical limits, but if you were handling so much data that started to become an issue I’d expect you’d have the expertise on hand to manage it rather than having to ask us.
I highly doubt ERP/Kinetic has some kind of limit beyond the underlying DB.
Theoretically, you’re limited by the unique index comprising the primary key. Sometimes a poorly considered int index can hit the ceiling (a bit over 2 billion) and shut something down. UD tables have compound indexes, so the theoretical limit will be the product of maximum data size of each field in the index, so with generally 5 fields of nvarchar(50) you’re going to run out of universe to write on first.
Practically, compound indexes are quite inefficient, exponentially so without skilled maintenance. Read performance will enforce consequences on data sizes. I’d guess somewhere between 10^5 and 10^7 rows, depending on your DBA.
2 Likes