anewt-developers team mailing list archive

["Wouter Bolsterlee \(uws\)" <uws+launchpad@xxxxxxxxx>]

Public bug reported:

AnewtDatabasePreparedQuery::executev() calls
AnewtDatabaseConnection::connect(), which calls
AnewtDatabaseConnection::is_connected(). This results in needless
database roundtrips and hence a performance penalty for (at least) MySQL
connections, since the is_connected() call results in a MySQL::ping()
call.

A better approach is described here: 
http://www.mysqlperformanceblog.com/2010/05/05/checking-for-a-live-database-connection-considered-harmful/

** Affects: anewt
     Importance: Medium
         Status: Triaged


** Tags: database

-- 
Do not call connect() for each executed query
https://bugs.launchpad.net/bugs/604821
You received this bug notification because you are a member of Anewt
developers, which is subscribed to Anewt.