I have a DBInput that have a database with a list of user with email and phone number, and people can make change to that DB, which include delete a row. The problem that I encounter is, the data that already indexed retain the deleted row in the DB, and thus the alert still send to that already deleted contact. So I want to find a way to reindex that db on a daily basis and delete the last indexed data.
I have 3 solotions that I think of:
1. Setup an alert that run |delete daily and DBConnect can reindex (but I have to manually set the rising column check point to 0)
2. Batch input them daily and setup my search (it's a join in an alert) to search for -1d since it's not big of a data.
3. Join the table directly within SQL query when I indexing them, that way it'll always have the updated DB (but it'll tank on the DB server side)
Which of these 3 solutions do you think is good? Or can you offer me an alternate, better solutions?