XE 속도 향상 팁

741번째줄에?

$count_query = sprintf('select count(*) as "count" %s %s', 'FROM ' . $queryObject->getFromString($with_values), ($temp_where === '' ? '' : ' WHERE ' . $temp_where));

아래에

?$count_cache = FileHandler::readFile('./files/cache/queries/total_count_'.md5($queryObject->getFromString($with_values)).'.php');

? ?if($count_cache)

? ?{

? ? if(strlen($count_cache) < 2024)

? ? {

? ? ?$count_cache = unserialize(str_replace(array('<!--?php /**','**/ ?-->'),array('',''),$count_cache));

? ? ?if($count_cache[md5($count_query)])

? ? ?{

? ? ? // cache count for 30 seconds.

? ? ? if(time() - $count_cache[md5($count_query)]['mtime'] &lt; 30)

? ? ? {

? ? ? ?$count_output = unserialize($count_cache[md5($count_query)]['data']);?

? ? ? }

? ? ? else

? ? ? {

? ? ? ?unset($count_cache[md5($count_query)]);

? ? ? }

? ? ?}

? ? }

? ? else

? ? {

? ? ?// remove too much big cache file.

? ? ?$count_cache = FileHandler::removeFile('./files/cache/queries/total_count_'.md5($queryObject-&gt;getFromString($with_values)).'.php');

? ? }

? ?}

넣어주시고 그아래 760번째 줄 쯤... 에 있는

$count_query .= (__DEBUG_QUERY__ &amp; 1 &amp;&amp; $queryObject-&gt;queryID) ? sprintf(' ' . $this-&gt;comment_syntax, $queryObject-&gt;queryID) : '';

$result_count = $this-&gt;_query($count_query, $connection);

$count_output = $this-&gt;_fetch($result_count);

이 것을

$count_query .= (__DEBUG_QUERY__&amp;1 &amp;&amp; $queryObject-&gt;queryID)?sprintf (' '.$this-&gt;comment_syntax, $queryObject-&gt;queryID):'';

? ? ? ? ? ? if(!isset($count_output))

? ?{

? ? ? ? $result_count = $this-&gt;_query($count_query, $connection);

? ? ? ? $count_output = $this-&gt;_fetch($result_count);

? ? $count_cache1[md5($count_query)]['data'] = serialize($count_output);

? ? $count_cache1[md5($count_query)]['mtime'] = time();

? ? $count_cache1[md5($count_query)]['count_query'] = $count_query;

? ? FileHandler::writeFile('./files/cache/queries/total_count_'.md5($queryObject-&gt;getFromString($with_values)).'.php','<!--?php /**'.serialize($count_cache1).'**/ ?-->');

? ?}