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

    • Dean_Nelson
    • 2 yrs ago
    • Reported - view

    I have the same problem.  Did you ever find a fix?

    • Fred
    • 2 yrs ago
    • Reported - view

    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.

    • Mel_Charles
    • 2 yrs ago
    • Reported - view

    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