http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10611

Paul Poulain <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         QA Contact|[email protected] |[email protected]
                   |y.org                       |

--- Comment #17 from Paul Poulain <[email protected]> ---
I made some tests with NYTProf, on opac-main.pl

* without the patch
 if (defined($context->{"dbh"}) && $context->{"dbh"}->ping()) {
 # spent 13.5ms making 120 calls to DBI::db::ping, avg 112µs/call

=> 120 pings are sent to mysql

* with the patch
121    1.10ms    if ( defined $db_driver && $db_driver eq 'mysql' &&
$context->{"dbh"} ) {
            return $context->{"dbh"};
        } elsif ( defined $db_driver && defined($context->{"dbh"}) &&
$context->{"dbh"}->ping()) {
            return $context->{"dbh"};
        }

=> no pings sent, even if the 120 calls are still here.

We spent on ly 1.10ms instead of 13.5 in those checks. And the lag will be much
larger in case of a "slow" network mySQL

-- 
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[email protected]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to