Are there performance advantages to having less it...
# general
e
Are there performance advantages to having less items in NetSuite? Our company makes a ton of custom products - so our marketing team has come up with ~1,000,000 products to put on our webpage... but a very small number of those 1,000,000 actually sell / have sold. We currently have all 1,000,000 in NetSuite... "in case" someone purchases it from our website. But I'm wondering if we should delete the 950,000 items we've never sold, and just add items 1 by 1 as they get purchased from our website. (I've already built a very easy way to create items in NetSuite by pulling information from our website)
s
In general I find that the more data you have in NS the slower it becomes.
e
Good to know. I also see a huge advantage when it comes to things like updating prices. Right now if we want to update prices, I have to update 1,000,000 items... where that price change can be made on our website in 5 minutes, and then when the items are brought into NetSuite 1 by 1, they will have the new price. Then I just need to update the ~25,000 items already in NetSuite, rather than 1,000,000