Jan-17-2024, 10:16 AM
- What interface are you using to manage the database? Does it hang or experience slowness?
- Did you try another language, does it also hangs or just python?
- Is your table large or did you indexes get dropped? Do you have dependencies in the data? Does this procedure execute properly if you do it through your DBMS interface?
- Have you look at the driver documentation, perhaps there is a known bug? Are you using the latest version? Is your driver version compatible with you python version?
- Check your connection string. Maybe there is something there that makes it behave weirdly. Try creating it in a different way.
- What OS are you running? Do you have a firewall/antivirus thing running? Perhaps they are killing your connection, try to disable them and see what happens.
- In my experience sometimes databases can work better if you "ping" them. Try to connect, and then disconnect and reconnect. Does it make any difference? How long does it take to connect?
- Is you DB hosted on your computer? Is it on a separate disk? Maybe that disk has issues/bad sectors/is dying. Check it's health.
- Did you try another language, does it also hangs or just python?
- Is your table large or did you indexes get dropped? Do you have dependencies in the data? Does this procedure execute properly if you do it through your DBMS interface?
- Have you look at the driver documentation, perhaps there is a known bug? Are you using the latest version? Is your driver version compatible with you python version?
- Check your connection string. Maybe there is something there that makes it behave weirdly. Try creating it in a different way.
- What OS are you running? Do you have a firewall/antivirus thing running? Perhaps they are killing your connection, try to disable them and see what happens.
- In my experience sometimes databases can work better if you "ping" them. Try to connect, and then disconnect and reconnect. Does it make any difference? How long does it take to connect?
- Is you DB hosted on your computer? Is it on a separate disk? Maybe that disk has issues/bad sectors/is dying. Check it's health.