Performance issues with Opencart 3.0.2.0 ?

Code: Select all

$data['scripts'] = $this->document->getScripts('footer');

Code: Select all

if ((!empty($this->session->data['user_token']) || (!empty($this->session->data['token']))) && defined("PRINT_STATS") && PRINT_STATS == 1) {
			//-----------------------------------------------------
			//--- GZip Compression Monitor ------------------------
			//-----------------------------------------------------
			$do_gzip_compress = 0;
			
			if ($this->config->get('config_compression')) {
				if (get_php_version() >= 40004) {
					if (extension_loaded("zlib")) {
						ob_start("ob_gzhandler");
					}
				} elseif (get_php_version() > 40000 && isset($this->request->server['HTTP_ACCEPT_ENCODING'])) {
					if (preg_match("/gzip/i", $this->request->server["HTTP_ACCEPT_ENCODING"]) || preg_match("/x-gzip/i", $this->request->server["HTTP_ACCEPT_ENCODING"])) {
						if (extension_loaded("zlib")) {
							$do_gzip_compress = 1;
							
							ob_start();
							
							ob_implicit_flush(0);
						}
					}
				}
			}
			
			$start_time = microtime();
			
		    $starttime = explode(" ", $start_time);
			
		    $endtime = explode(" ", microtime());
			
		    $total_time = $endtime[0] - $starttime[0] + $endtime[1] - $starttime[1];
			
		    $sql_time = $this->db->getQueryTime();
			
		    $php_time = $total_time - $sql_time;
			
		    $gzip_text = ($this->config->get('config_compression') ? "GZIP compression enabled" : "GZIP compression disabled");
			
		    $gzip_text .= ($this->config->get('config_compression') && !extension_loaded("zlib") ? "*" : "");
			
		    printf("<p align=\"center\"><font size=\"-2\">Page generated in %f seconds with ".$this->db->getQueryCount() . " queries, spending %f seconds doing MySQL queries and %f doing PHP things. $gzip_text</font></p>", $total_time, $sql_time, $php_time);
		}

		if ((!empty($this->session->data['user_token']) || (!empty($this->session->data['token']))) && defined("PRINT_QUERIES") && PRINT_QUERIES == 1) {
		    echo implode('<br><br>', $this->db->getQueryArray());
		}

		if ((!empty($this->session->data['user_token']) || (!empty($this->session->data['token']))) && $do_gzip_compress && isset($this->request->server['HTTP_ACCEPT_ENCODING'])) {
			if (preg_match("/gzip/i", $this->request->server['HTTP_ACCEPT_ENCODING'])) {
				$encoding = "gzip";
			} elseif (preg_match("/x-gzip/i", $this->request->server["HTTP_ACCEPT_ENCODING"])) {
				$encoding = "x-gzip";
			}

			$gzip_contents = ob_get_contents();
		  
			ob_end_clean();

			if (defined("PRINT_STATS") && PRINT_STATS == 1) {
				$s = sprintf ("\n<!-- Use Encoding:         %s -->", $encoding);
			
				$s .= sprintf("\n<!-- Not compress length:  %s -->", strlen($gzip_contents));
			
				$s .= sprintf("\n<!-- Compressed length:    %s -->", strlen(gzcompress($gzip_contents, $this->config->get('config_compression'))));
			
				$gzip_contents .= $s;
			}

			$gzip_size = strlen($gzip_contents);
		  
			$gzip_crc = crc32($gzip_contents);

			$gzip_contents = gzcompress($gzip_contents, $this->config->get('config_compression'));
		  
			$gzip_contents = substr($gzip_contents, 0, strlen($gzip_contents) - 4);

			header("Content-Encoding: $encoding");
		  
			echo "\x1f\x8b\x08\x00\x00\x00\x00\x00";
		  
			echo $gzip_contents;
		  
			echo pack("V", $gzip_crc);
		  
			echo pack("V", $gzip_size);
		}

Code: Select all

private $connection;

Code: Select all

private $query_time = 0;
private $query_count = 0;	
private $query_array = array();

Code: Select all

$result->rows = $data;

Code: Select all

if ((defined("PRINT_QUERIES") && PRINT_QUERIES == 1) || (defined("PRINT_STATS") && PRINT_STATS == 1)) {
                                        $startsqltime = explode(" ", microtime());
                                        
					$endsqltime = explode(" ", microtime());
					
					$totalsqltime = round($endsqltime[0] - $startsqltime[0] + $endsqltime[1] - $startsqltime[1], 3);
					
					$this->query_time += $totalsqltime;
					
					$this->query_count++;
				}
				
				if (defined("PRINT_QUERIES") && PRINT_QUERIES == 1) {
					$query_stats = htmlentities($sql);
					
					$query_stats .= "<br><b>Querytime:</b> ".$totalsqltime;
					
					$this->query_array[] = $query_stats;
				}

Code: Select all

public function escape($value) {

Code: Select all

public function getQueryCount() {
		return $this->query_count;
	}
	
	public function getQueryTime() {
		return $this->query_time;
	}
	
	public function getQueryArray() {
		return (array)$this->query_array;
	}

Code: Select all

/**
     * 
     *
     * @param	string	$value
	 * 
	 * @return	string
     */
	public function escape($value) {

Code: Select all

public function getQueryCount() {
		return $this->adaptor->getQueryCount();
	}
	
	public function getQueryTime() {
		return $this->adaptor->getQueryTime();
	}
	
	public function getQueryArray() {
		return $this->adaptor->getQueryArray();
	}		

Code: Select all

define('PRINT_STATS', 1);
define('PRINT_QUERIES', 0);

Code: Select all

define('PRINT_STATS', 1);
define('PRINT_QUERIES', 1);