| Bug #71525 | IS_CONNECTED() IS CHECKED EVERY TIME A STATEMENT IS EXECUTED | ||
|---|---|---|---|
| Submitted: | 30 Jan 2014 12:21 | Modified: | 13 Jan 2015 7:53 |
| Reporter: | Alfranio Correia | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Fabric | Severity: | S3 (Non-critical) |
| Version: | 1.4.0 | OS: | Any |
| Assigned to: | Alfranio Correia | CPU Architecture: | Any |
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.021 sec. using MySQL 8.0.17-commercial
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
© 2019, Oracle Corporation and/or its affiliates
Description: is_connected() is checked every time a statement is executed. This is not really necessary and reduces the overall performance. How to repeat: Check the code: def exec_mysql_stmt(cnx, stmt_str, options=None): ... if cnx is None or not cnx.is_connected(): raise _errors.DatabaseError("Invalid database connection.") Suggested fix: Improve the code and check whether a connection is fine or not only right after retrieving it from the pool.