A little survey here, I'm curious to know how many products you have in your F&O installations ? We are coming from AX2012 and now using FinOps. We should have more than a million items in the database sooner or later (let's say probably 600 / 700 000 without variants, and more than a million with variants). And I would like to know if many of you have a similar size in the database, and share our experiences about how to manage such a big database. Any feedback will be more than welcome : )
I did not notice any performance degradation with that number of items. The only issue is having many items / customers at POS level ( if you are using POS )
Hi François,
We have a few customers with more than 1 million items in the repository in single products or master products. However, this requires a considerable effort to maintain the repository.
Functionally
1- you must have a clear procedure for creating articles. (Ideally you should have an EDI with your partners for the creation of articles)
2- Managing the PLM can be a great help.
Technically
1- You need to make an audit on the database to determine which indexations would be the most useful.
2- Use XDS filters for the roles defined to filter the items on the transactional forms in order to minimize the response and processing time of these forms.
3- If possible, it is necessary to use injections of the lines of the transactional forms to gain in response time and reliability of the data.
Regards,
Mehdi
Thanks for your answer and all the details !
I wish EDI was possible with the suppliers, but they all provide only Excel or CSV files with a quality of data that goes from good to terrible (and the data format is often changing every year, otherwise it's less fun...).
We have an ETL though, to transform all this in the right format for import. Are your customers using the standard import tool ?
Also, do you know how many people are working on the product import/update ? We are a very small team, so I'm curious about the size of ressources put on that effort in other companies.
So far, it's not really a performance issue. We don't use POS. It's more about the integration / maintenance of the products. How they import, update, close. What kind of tools they are using, and how many people are working on that.
Without knowing all the details, it will be complicated to suggest a good approach.
You can import CSV product information using data entities without major issues. If you start having large files > 100K products, you might consider custom entities for have a better performance.
But is not normal having 100k products to import it daily. You should consider importing only products with updates or new.
You can automate all the process for import / updating products if you have a standard CSV file with data.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 2,188
André Arnaud de Cal... 868 Super User 2025 Season 2
Sohaib Cheema 593 User Group Leader
