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.
