How to skip an iteration in Python for-loop when a particular statement is taking more time to execute?

Asked Jan 23 '21 at 07:29

Active Jan 23 '21 at 13:11

Viewed 82 times

I have a read_sql call inside a for loop, which takes a lot of time to return a value sometimes. Is it possible to skip the loop when it is taking more than 5 mins to execute read_sql?


for i in range(columns):
    value=pd.read_sql() # skip this statement when it takes more than 5 mins to return
    # other operation

edited Jan 23 '21 at 13:11

geertjanvdk

3,440
24
26

asked Jan 23 '21 at 07:29

Sreehari Karthikeyan

2

you can use `Threading` with `timeout` to timeout code exeuction. – Krishna Chaurasia Jan 23 '21 at 07:33
https://stackoverflow.com/questions/2196999/how-to-add-a-timeout-to-a-function-in-python this will help. – r.burak Jan 23 '21 at 10:22

How to skip an iteration in Python for-loop when a particular statement is taking more time to execute?

0 Answers0