Brandie Tarvin (10/22/2012)
baabhu (10/20/2012)
Brandie Tarvin (10/19/2012)
I have an odd question. Why do you need to delete 10000 records from your database every 4 minutes?This is an OLTP system with tokens needs to be updated every 4 minutes. We use staging table to do updates and move to the final table and remove the rows from staging.
Why not use TRUNCATE?
By the time job starts deleting, we have a delay of 0.5 seconds inside the job between batches for the new tokens to get inserted into the table. The token insertion will be happening from different process than the token delete job. That is the reason we have no used Truncate.