Deleting the database while other threads are active

Support
  • I use BAS (Browser Automation Studio) to develop a tool for scanning news articles on various online news websites. The tool runs 10 - 15 threads simultaneously, with each thread dedicated to a specific news website. During operation, I save the scanned links into a database to prevent re-scanning of old content.

    I plan to implement an additional function that automatically deletes the entire database at midnight to optimize its performance. However, I have the following concerns:

    1. Considering that the tool operates with multiple threads, if one thread attempts to delete the entire database while other threads are actively saving data into it, could the tool encounter errors or issues?

    2. How can I ensure that only one thread remains active at midnight to perform the database deletion process?

  • This post is deleted!