I'm interested to know if there is a fast way to delete all records in a table when dealing with high record counts.
There is an unpublished API to Purge all records in a table. Basically all you do is like
mycompany.quickbase.com/xxxxxxxx?a=GenPurge
But that comes back to the screen for user interaction to "confirm".
The difference in performance when deleting all records in a table with high record counts between ?a=GenPurge and ?act=PurgeRecords is that the former will delete say 1 million records in a second, and the other is like watching paint dry, even when there are no relationships. It would take minutes to complete.
My question is does anyone know if there is syntax to run that ?a=GenPurge without the user interaction so it can be used in a URL formula button as I want chain to then reload the table with new data.
Question
General Purge API?
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.