Curious if anyone has experience working around a potential performance issue. When a transaction (SO, Quote, Invoice) is loaded it loads all the address records related to the customer record. If a customer has let's say 1,000 ship-to addresses it could cause performance or timeout issues. We'd like to avoid having multiple entities if possible (that's the current suggestion). Does anyone have any experience working around this potential performance issue whether through data, script or other means?

Do you have the preference delay loading of sublists enabled? I'm very interested in learning if that helps your issue or if NetSuite loads all of them regardless.