B4X FEED MySQL DELETE Slowness ?

اطلاعات موضوع

درباره موضوع در تاریخ, در دسته b4xfeed ایجاد شده و آغاز کننده آن practicalsoftمی باشد و موضوع آن: MySQL DELETE Slowness ? است. این موضوع تا کنون 35 بازدید کننده و, 0 پاسخ داشته و 0 بار پسندیده شده...
نام دسته b4xfeed
نام موضوع MySQL DELETE Slowness ?
آغاز کننده موضوع practicalsoft
تاریخ شروع
پاسخ‌ها
0
بازدیدها
35
پسندها
0
آخرین ارسال توسط PracticalSoft
Jun 6, 2020
11,559
4,422
Hi there

Has anyone experienced this? How did you solve it?

The volume of my deletes are like 5 records at a time and soon after that I execute an insert, however the inserts happen first, thus the sequence flow is not followed.

So after some time, adding sleep between the deletes and the inserts worked, but this might be / might not be the best approach. Or perhaps instead of hard deletes I might have to do soft deletes?

Any thoughts?

Assumptions: PHP usage.

 

عقب
بالا