Not holding much hope of an answer due to previous experience on here but here goes:
I require many rows to be added to a collection at once, an average of 1500 a time.
If i was using a proper platform i would generate a large object and then insert all rows with one query.
so instead I loop the number of rows i need in a for each and insert with an await wix data insert. This is working up to around 500 or so rows where the system just stops reporting and nothing seems to be happening! checking the collection shows max 650 rows out of 1500!
does anyone please have any Ideas?
I do not have the time to write, yet another, function that checks how many and where the function failed and then re attempt to insert the failed rows. This will be extremely difficult as the data used to generate these rows could potentially be gone...
This is absolutely unreliable and unacceptable!
Thanks in advance
EDIT: I'm also using the script on this page: https://www.wix.com/code/home/forum/community-discussion/clear-collection-data-at-once
to remove all rows in a collection. There's around 650 rows yet it keeps failing at 2-300 rows everytime! this is unacceptable!