moqui-framework icon indicating copy to clipboard operation
moqui-framework copied to clipboard

Data import does not support batch insertion operations

Open daiagou opened this issue 2 years ago • 1 comments

Moqui's tools include dataimport, but they do not support batch operations. When there is a large amount of data, there will be timeout/failure issues. At this point, the timeout time can be increased (default 60s), But there are several issues:

  1. When deploying online, Moqui is usually not external, and the outermost layer usually has nginx/address. However, changing the Moqui timeout does not take effect.
  2. Due to the lack of batch operations, the import process is very slow. Even if Ops personnel agree to adjust the timeout time, this time cannot be estimated due to the amount of data. Usually, it is not recommended to adjust the timeout to a very large value. So it is recommended to determine whether the imported data is duplicate and can support batch inserts? Especially for importing in CSV format.

daiagou avatar Jun 02 '23 02:06 daiagou

Could you provide some further examples of what exactly is occurring? Repeatable steps, so that others can help to isolate what the problem(s) actually are?

eigood avatar Jun 09 '23 19:06 eigood