Quick question
How many records can a custom record hold in Netsuite
a
Anthony OConnor
08/09/2024, 3:25 PM
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
Legion
08/09/2024, 3:25 PM
I have arround a million records
a
Anthony OConnor
08/09/2024, 3:27 PM
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
Anthony OConnor
08/09/2024, 3:28 PM
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
Anthony OConnor
08/09/2024, 3:31 PM
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