FM / tests

/var/www/vhosts/ihelp.ro/httpdocs/vendor/jdorn/sql-formatter/tests/

/var/www/vhosts/ihelp.ro/httpdocs/vendor/jdorn/sql-formatter/tests

Name	Size	Mode	Actions
clihighlight.html	28018	0644	edit dl rm
compress.html	11397	0644	edit dl rm
format-highlight.html	71309	0644	edit dl rm
format.html	14670	0644	edit dl rm
highlight.html	68256	0644	edit dl rm
performance.php	1343	0644	edit dl rm
sql.sql	11747	0644	edit dl rm
SqlFormatterTest.php	5004	0644	edit dl rm

Edit: /var/www/vhosts/ihelp.ro/httpdocs/vendor/jdorn/sql-formatter/tests/performance.php (1343B)

<?php
require '../lib/SqlFormatter.php';

//this is the default value
//set to '0' to disable caching
//a value between 10 and 20 seems to give the best result
SqlFormatter::$max_cachekey_size = 15;

//the sample query file is filled with install scripts for PrestaShop
//and some sample catalog data from Magento
$contents = file_get_contents('sql.sql');

//queries are separated by 2 new lines
$queries = explode("\n\n",$contents);

//track time and memory usage
$start = microtime(true);
$ustart = memory_get_usage(true);

//track number of queries and size of queries
$num = 0;
$chars = 0;

foreach ($queries as $query) {
	//do formatting and highlighting
	SqlFormatter::format($query);
	
	$num++;
	$chars += strlen($query);
}

$uend = memory_get_usage(true);
$end = microtime(true);

echo "<p>Formatted ".$num." queries using a max_cachekey_size of ".SqlFormatter::$max_cachekey_size."</p>";

echo "<p>Average query length of ".number_format($chars/$num,5)." characters</p>";

echo "<p>Took ".number_format($end-$start,5)." seconds total, ".number_format(($end-$start)/$num,5)." seconds per query, ".number_format(1000*($end-$start)/$chars,5)." seconds per 1000 characters</p>";

echo "<p>Used ".number_format($uend-$ustart)." bytes of memory</p>";

echo "<h3>Cache Stats</h3><pre>".print_r(SqlFormatter::getCacheStats(),true)."</pre>";

Formatted ".$num." queries using a max_cachekey_size of ".SqlFormatter::$max_cachekey_size."

"; echo "

Average query length of ".number_format($chars/$num,5)." characters

"; echo "

Took ".number_format($end-$start,5)." seconds total, ".number_format(($end-$start)/$num,5)." seconds per query, ".number_format(1000*($end-$start)/$chars,5)." seconds per 1000 characters

"; echo "

Used ".number_format($uend-$ustart)." bytes of memory

"; echo "

Cache Stats

".print_r(SqlFormatter::getCacheStats(),true)."