trieb-work / schemabase

The schemabase Integration framework to build custom data movers between different cloud services. Using BullMQ, Webhooks, Prisma Database and more
https://schemabase.app
MIT License
5 stars 2 forks source link

Saleor syncToECI product sync creating high DB load #426

Open JannikZed opened 1 year ago

JannikZed commented 1 year ago

This run creates somehow high load on the DB because of unknown reason. We need to improve the logic here and make sure, that we don't update products too often - the updateAt timestamp does still not reflect the reality, which makes us update a lot in Saleor and makes us pull product changes back.. we need to improve here Furthermore, we need to find out, why this run is creating such high DB load- somehow it is related to large update call (OrderLineItems) - we don't know, what prisma is doing here. No other sync job is taking that high load.