Hello everyone,
I had a concern about DB locks lately.
If have a scenario where in a Cron job is running. This cron job updates a table and would take about 20 minutes to complete.
In the meantime, if I query the same table using an application, will my application have to wait as the cron job has held a write lock on the table or the application gets the latest available snapshot of the data?
Please let me know.
Thanks,
Jas
