Problem with missing records after Database update

Ask the community
,
1

Hello!! I already asking, but I try to describe problem more clear.

Can You help me find answer one one important question.

I try solve one problem during week or more and cannot.
I write code and it work in evarage
but when I try update my database in FOR loop
with big amount of Rows - some of this rows lost…

If I update 10 rows - It’s working
If I manually change index in FOR statements (0-10, next 11-20, next 21- 30…)
Finally Database records updated completely, but if I run "FOR from 0 to 90 -
30% of records (rows) not updated… lost (stay in previous data state)

I guess that problem with time responding database and I errors happened
when I try to write until database ready, but I cannot find answer nowhere…
How be sure that database ready again

AND

I read advice Put Dataset in ONREADY and Functions in ONREADY
And I understand в that mistakes happened because Database not
ready when I make to much requests
But

  1. How I put my ONCLICK Button external function inside Onready?
    It’s impossible

  2. When I put database Refresh inside ONREADY some Table wit my datasate Refreshed on screen… (this is obvious)

I will be appreciate any help…
Thank You in advance.
Sincerely, Misha

Here code fragment…
in FOR loop i put index values 70 - 81
to show that with small amount of - update working.
If I put 0-91 - 30% of records - not updated

export function button3_click(event) {

let i = 0;
let recid = 1;

  wixData.query("dbBardSongs") 
       .eq("bardName", selectedKey) 
       .limit(130) 
       .find() 
       .then( (results1) => {

for (i=90; i<98; i++) {
recid = results1.items[i]._id;
onerecord2(i, recid);
}

  }) 
  .catch((err) => {

//let errorMsg = err;
console.log("Error in Query = ");
console.log(err);
});
}

export function onerecord2 (index, recid) {
let i = index;
wixData.get(“dbBardSongs”, recid)
.then((toUpdate) => {
toUpdate.orderNumber = (i + 1);
wixData.update(“dbBardSongs”, toUpdate)
.then((result) => {
})
.catch((err) => {
//let errorMsg = err;
console.log("Eror in Update = ");
console.log(err);
});
})
.catch((err) => {
//let errorMsg = err;
console.log("Error with Get = ");
console.log(err);
});

}

Almost All Error I receive in CATCH “Error in Get” but No CODE of Error - Just word “Error”

2

Mazel, this thing has come up a couple of times before. It looks like doing a lot of db-actions (1 insert/update per record inside a loop) is too much. The usual answer is: use bulkUpdate instead of updating every single row/record on its own. https://www.wix.com/corvid/reference/wix-data.html#bulkUpdate

3

Thank You for answering I will look Your Link

4

Thank You for Your advice. I check it. I understand. But… I deed without error 15 simalteniously, with 20 - Error. This is not Solve problem if I need update big amount of records. I think there Certain amount like 10-or 15 records for simalteniosly update after them we need do some “pause” before next “bulk” in bulk or loop algorithm