Quick question How many records can a custom recor...
# suitescript
l
Quick question How many records can a custom record hold in Netsuite
a
I'm not sure what the upper limit is? if there even is a hard limit. 100k wouldn't be an issue for sure... more than that and I think you'll still be fine, but search, and making unfiltered dropdowns for that record in field or searches or queries will potentially start seeing performance issues
l
I have arround a million records
a
yeah i don't think there is a hard limit, I'm not aware of one. but yeah if you're getting millions of search results that's a LOT of data to process, so you need to filter aggressive or use caching and stuff to make things work faster
for performance it also depends what is IN the record.. if its just an internal id, and 3 other columns, probably still not an issue, but if its a huge record with 100s of fields... again performance is gonna take a hit if you're pull all that stuff back
you could also maybe setup something to clean up old records that aren't needed anymore, if that's realistic? depends on your use case obviously