Ninox DB shuts down with large Deletes
When I delete a large amount of records (30k or so) - either with a button (delete select 'table') or by going to the table and doing 'select all' and 'delete' - the database shuts down (either returns me to my list of databases, or hangs and I have to force quit Ninox). When I reopen the database - the records are not deleted.
No issues with smaller volumes - not sure the exact threshold that causes the error. Using a Mac - just recently upgraded to Big Sur - but was occurring prior to my upgrade as well ( I was hoping Big Sur might fix the issue but it did not).
3 replies
-
I have the same problem. Did you ever find a fix?
-
It is a known issue with Ninox as I submitted a ticket with them about this as well. Who knows when they will fix it. I sent the email back in Dec 2021 in v3.5.8 and now they are on v13 and I don't see any word about fixing the issue.
-
I had same issue but as a work around I now delete large quantities in smaller batches.
The way I work this is to have a batch number in my data. so initially instead of doing a big delete I set the records to have a batch number ready for delete (i just extract the month of the date ie 06 etc)
Then when I log in each day I have a global script tha runs to hunt for the lowest batch number and delete the records that way
seems to work okay
Content aside
- 2 yrs agoLast active
- 3Replies
- 373Views