Watson Commerce Ideas
Submit ideas for other Watson Customer Engagement Products:
• Watson Marketing
• Watson Supply Chain
During an OMoC initial dataload there can be a need to upload 1M+ item records to the YFS_ITEM DB table. This table is initially empty and non indexed. This can make the dataload INSERT take a very long time when using the ManageItem API. There is a need for the YFS_ITEM table to first be Indexed and possibly primed with records, and then a runstats needs to be run, as we have seen INSERTs running that do not initially use the Index, and the accompanying SEARCH to an INSERT is a huge overhead for the dataload. We need the YFS_TABLE and the ManageItem API to use Indexing by default OOB, and the YFS_ITEM table to be indexed OOB in an OMoC env. Please look at this request from a client dataload perspective. We need the recommended OOB dataload (from an MQ GET queue / ManageItem API ) to use most efficient way to run the underlying YFS_ITEM sql INSERT.
How will this idea be used?
This idea will be used across all OMoC clients for initial dataload, and subsequent updates using the ManageItem API and YFS_ITEM table.
|What is your industry?||Retail|
|What is the idea priority?||High|
|Link to original RFE|