Running IFS with millions of articles

Hi,

With “article” do you mean what we in IFS often refer to as “parts” (inventory, purchase, etc.), or something like “written articles”? (In Swedish, we use the word “artikel” for “part” in IFS).

If this is about parts, possibly another forum here is a better place to discuss that. For sure, parts are used in asset management, but I think the core of the part handling is in supply chain.

Or perhaps you did have an asset management perspective on it?

10 million parts is probably a lot, but I am sure we have customers that have a similar amount of them.

Now I will let you comment and we can see if we should move this thread to another forum or keep it here.

Thanks!

No worries. I moved the thread to Supply Chain. Let’s see if someone will have something interesting to say there :)

For what purposes do you use all these parts? Manufacturing? Service? Maintenance?

Without knowing in detail what flows and usage pattern the application is supposed to have I can give a general answer.

We have customers with similar volumes and Oracle is generally good at handing larger volumes.

Some advice given the data volumes you are talking about is to use custom query's carefully, in some cases indexes might need to be customized as well.