Hi all, As development goes on for a server project, it turns out that I am using the MySQLDB and DB interactions excessively. One questions is just bothering me, why don't we have a timeout for queries in PEP 249 (DB API)?
Is it really safe to wait for a query to finish, means, is it always returning, even if the DB server goes down? And, also from my point view, it may be a good feature. We may use long/non-critical DB queries with a timeout and slow/critical without a timeout. This will give us a little chance to prioritize/consume queries on their criticality? And, I don't see so much effort in implementing this. One has to change the socket logic in the related DB's API source code? What do you think? Thanks -- http://mail.python.org/mailman/listinfo/python-list