Php 8.1 SC slow in deploy to production and user request

Mauricio_Iturriaga · October 19, 2022, 1:32pm

Since I changed to version php 8.1 the deploy in production is very slow, and my users tell me that app is more slow too, some one happen the same?

alvagar · October 19, 2022, 2:05pm

Hi, i did migration of my project to PHP 8.1 to my server and It is working fine.

Nico · October 20, 2022, 8:26am

I did the migration and found that Applications run faster as well as the deployment

Nico · October 20, 2022, 1:29pm

So, here is a nifty speed test that I found courtesy of Alessandro Torrisi

create a blank app
In the on Execute and add one line echo speed();
In PHP Methods create php method speed with the info below.
Run the app

/**

PHP Script to benchmark PHP and MySQL-Server.
inspired by / thanks to:
- www.php-benchmark-script.com (Alessandro Torrisi)
- www.webdesign-informatik.de
@license MIT
*/

// -----------------------------------------------------------------------------
// Setup
// -----------------------------------------------------------------------------
set_time_limit(120); // 2 minutes

$options = [];

// Show or hide the server name and IP address
$showServerName = false;
// $options[‘db.host’] = $this->Db->server;
$options[‘db.host’] = ‘localhost’;
$options[‘db.user’] = $this->Db->user;
$options[‘db.pw’] = $this->Db->password;
$options[‘db.name’] = $this->Db->database;

// -----------------------------------------------------------------------------
// Main
// -----------------------------------------------------------------------------
// check performance
$benchmarkResult = test_benchmark($options);

// benchmark.php?json
if (isset($_GET[‘json’])) {
// Json output
header(‘Content-Type’, ‘application/json’);
echo json_encode($benchmarkResult, JSON_PRETTY_PRINT);
} else {
// html output
echo print_html_result($benchmarkResult, $showServerName);
}

exit;

// -----------------------------------------------------------------------------
// Benchmark functions
// -----------------------------------------------------------------------------

function test_benchmark(array $settings)
{
$result = [];
$result[‘version’] = ‘1.6’;
$result[‘sysinfo’][‘time’] = date(‘Y-m-d H:i:s’);
$result[‘sysinfo’][‘php_version’] = PHP_VERSION;
$result[‘sysinfo’][‘platform’] = PHP_OS;
$result[‘sysinfo’][‘server_name’] = $_SERVER[‘SERVER_NAME’];
$result[‘sysinfo’][‘server_addr’] = $_SERVER[‘SERVER_ADDR’];
$result[‘sysinfo’][‘xdebug’] = in_array(‘xdebug’, get_loaded_extensions());

$timeStart = microtime(true);

test_math($result);
test_string($result);
test_loops($result);
test_ifelse($result);

$result['benchmark']['calculation'] = timer_diff($timeStart) . ' sec.';

if (isset($settings['db.host'])) {
    test_mysql($result, $settings);
}

$result['benchmark']['total'] = timer_diff($timeStart) . ' sec.';

return $result;

}

function test_math(&$result, $count = 99999)
{
$timeStart = microtime(true);

for ($i = 0; $i < $count; $i++) {
    sin($i);
    asin($i);
    cos($i);
    acos($i);
    tan($i);
    atan($i);
    abs($i);
    floor($i);
    exp($i);
    is_finite($i);
    is_nan($i);
    sqrt($i);
    log10($i);
}

$result['benchmark']['math'] = timer_diff($timeStart) . ' sec.';

}

function test_string(&$result, $count = 99999)
{
$timeStart = microtime(true);

$string = 'the quick brown fox jumps over the lazy dog';
for ($i = 0; $i < $count; $i++) {
    addslashes($string);
    chunk_split($string);
    metaphone($string);
    strip_tags($string);
    md5($string);
    sha1($string);
    strtoupper($string);
    strtolower($string);
    strrev($string);
    strlen($string);
    soundex($string);
    ord($string);
}
$result['benchmark']['string'] = timer_diff($timeStart) . ' sec.';

}

function test_loops(&$result, $count = 999999)
{
$timeStart = microtime(true);
for ($i = 0; $i < $count; ++$i) {
}

$i = 0;
while ($i < $count) {
    ++$i;
}

$result['benchmark']['loops'] = timer_diff($timeStart) . ' sec.';

}

function test_mysql(&$result, $settings)
{
$timeStart = microtime(true);

$link = mysqli_connect($settings['db.host'], $settings['db.user'], $settings['db.pw']);
$result['benchmark']['mysql_connect'] = timer_diff($timeStart) . ' sec.';
mysqli_select_db($link, $settings['db.name']);
$result['benchmark']['mysql_select_db'] = timer_diff($timeStart) . ' sec.';

$dbResult = mysqli_query($link, 'SELECT VERSION() as version;');
$arr_row = mysqli_fetch_array($dbResult);
$result['sysinfo']['mysql_version'] = $arr_row['version'];
$result['benchmark']['mysql_query_version'] = timer_diff($timeStart) . ' sec.';

$query = "SELECT BENCHMARK(1000000, AES_ENCRYPT('hello', UNHEX('F3229A0B371ED2D9441B830D21A390C3')));";
mysqli_query($link, $query);
$result['benchmark']['mysql_query_benchmark'] = timer_diff($timeStart) . ' sec.';

mysqli_close($link);

$result['benchmark']['mysql_total'] = timer_diff($timeStart) . ' sec.';

return $result;

}

function timer_diff($timeStart)
{
return number_format(microtime(true) - $timeStart, 3);
}

$result = '<table cellspacing="0">';
$result .= '<thead><tr><th>System Info</th><th></th></tr></thead>';
$result .= '<tbody>';
$result .= '<tr class="even"><td>Version</td><td>' . h($data['version']) . '</td></tr>';
$result .= '<tr class="even"><td>Time</td><td>' . h($data['sysinfo']['time']) . '</td></tr>';

if (!empty($data['sysinfo']['xdebug'])) {
    // You are running the benchmark with xdebug enabled. This has a major impact on runtime performance.
    $result .= '<tr class="even"><td>Xdebug</td><td><span style="color: darkred">'
        . h('Warning: Xdebug is enabled!')
        . '</span></td></tr>';
}

$result .= '<tr class="even"><td>PHP Version</td><td>' . h($data['sysinfo']['php_version']) . '</td></tr>';
$result .= '<tr class="even"><td>Platform</td><td>' . h($data['sysinfo']['platform']) . '</td></tr>';

if ($showServerName == true) {
    $result .= '<tr class="even"><td>Server name</td><td>' . h($data['sysinfo']['server_name']) . '</td></tr>';
    $result .= '<tr class="even"><td>Server address</td><td>' . h($data['sysinfo']['server_addr']) . '</td></tr>';
}

$result .= '</tbody>';

$result .= '<thead><tr><th>Benchmark</th><th></th></tr></thead>';
$result .= '<tbody>';
$result .= '<tr><td>Math</td><td>' . h($data['benchmark']['math']) . '</td></tr>';
$result .= '<tr><td>String</td><td>' . h($data['benchmark']['string']) . '</td></tr>';
$result .= '<tr><td>Loops</td><td>' . h($data['benchmark']['loops']) . '</td></tr>';
$result .= '<tr><td>If Else</td><td>' . h($data['benchmark']['ifelse']) . '</td></tr>';
$result .= '<tr class="even"><td>Calculation total</td><td>' . h(
        $data['benchmark']['calculation']
    ) . '</td></tr>';
$result .= '</tbody>';

if (isset($data['sysinfo']['mysql_version'])) {
    $result .= '<thead><tr><th>MySQL</th><th></th></tr></thead>';
    $result .= '<tbody>';
    $result .= '<tr><td>MySQL Version</td><td>' . h($data['sysinfo']['mysql_version']) . '</td></tr>';
    $result .= '<tr><td>MySQL Connect</td><td>' . h($data['benchmark']['mysql_connect']) . '</td></tr>';
    $result .= '<tr><td>MySQL Select DB</td><td>' . h($data['benchmark']['mysql_select_db']) . '</td></tr>';
    $result .= '<tr><td>MySQL Query Version</td><td>' . h($data['benchmark']['mysql_query_version']) . '</td></tr>';
    $result .= '<tr><td>MySQL Benchmark</td><td>' . h($data['benchmark']['mysql_query_benchmark']) . '</td></tr>';
    $result .= '<tr class="even"><td>MySQL Total</td><td>' . h($data['benchmark']['mysql_total']) . '</td></tr>';
    $result .= '</tbody>';
}

$result .= '<thead><tr><th>Total</th><th>' . h($data['benchmark']['total']) . '</th></tr></thead>';
$result .= '</table>';

echo $result;

echo "\n</body></html>";

}

function h($v)
{
return htmlentities($v);
}

phillipkearns · May 16, 2023, 7:03am

I had to migrate to the ‘new’ scriptcase, and the development environment is painfully slow. To a point where Im trying to go back to php 7.

robydago · May 16, 2023, 10:31am

After migrating the SC dev environment from php7.3 to php8.1 on the same server, I have the same slow issue, but not when depolying.
The SC dev environemnt is now painfully slow at login and when opening projects.
After a project is open its speed is mostly back to where it was with php7.1

alvagar · May 16, 2023, 1:02pm

I have same issue. check task manager and look at cpu usage.

phillipkearns · October 1, 2023, 3:46pm

This is halarious, so much for the rapid development !

alvagar · October 2, 2023, 4:15pm

Test SC in Incognit Mode.