20k records isn't very many at all, you'd need to provide the case and code
Oct 4, 2017
9
Level 1
Need to process 10k records in same time.
I have 20k records products data. and 4 customer groups, and each record of product data have 4 price based on customer groups.
and once single customer group is modified, the system need to recalculate 20k records(deleting old one, select base price, calculate the new price, and then insert new one) or may be just update.
if there are new products by import.. 9k products, it means 9k, looping each, and recalculate base on 4 groups and insert.
but the process is really slow, and sometimes my server(im using ubuntu, n nginx) going to 404 not found. is there any tips?
*i have already use bulk insert. storing them into array and insert at the end.
Please or to participate in this conversation.