Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 5778 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted (edited)

During the current development stage of my project, I need to delete all records from certain tables before re-importing data again.

What confuses me is the incredibly slow speed to "delete all records." It seems to be deleting one record at a time, taking more than a second per 100 records deleted.

I'm still waiting for 550,000 records to be deleted, before I can start importing again (this was already a "reduced data set" which excluded files containing another 1.5 to 2 million records of source data; for the next few cycles I'll use an even smaller set of source files). At this pace, it will take more than 6,000 seconds (100 minutes) just to delete all these records. Then, of course, it will take several hours to re-import source data.

Am I missing something here? Surely there must be a quicker way to empty out a table? (And no, I don't want to save a clone of the file, since that would sacrifice the data from my other tables.)

Edited by Guest
Posted

Do you have any fields on the screen when deleting?

Any fields that are indexed may require their index to be reset after each record is deleted.

Watch out for calculation fields too, especially summaries.

Posted (edited)

I'm not sure how "having fields on the screen" would affect this; the screen isn't updated during the deletion process.

I assume that you are right that some (perhaps most) of the delay may come from updating the index. What I don't understand is, if I'm deleting all the records from a table (with no data from the table related to any other tables), why can't the entire table contents AND all index entries for the table be deleted together, much more quickly?

Edited by Guest
Posted

The screen still has to display any summary fields on there even for a split sec.

Posted

Thanks. My first reaction was, how could I possibly delete all records without having the records in the current view. The obvious answer was to use a short script (go to layout, show all, delete all). Sure enough, it was much faster.

This topic is 5778 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.