HI ,
My website have a few GB each month with cache folder.
Any comment how to deduce them? At this time, my hosting account have 95 Gb data... :blink:
Thanks you !
Printable View
HI ,
My website have a few GB each month with cache folder.
Any comment how to deduce them? At this time, my hosting account have 95 Gb data... :blink:
Thanks you !
What are the filenames in your cache folder?
Any files ending in .txt or .log can be removed.
If you have several "query_selects_*******.txt" files, you need to turn off Store Database Queries in Admin->Configuration->Logging
Hi,
I have some question : When i turn off cache , will my website run slow down or anything will happen ?
Thanks you !
What version of Zen Cart? What version(s) have you upgraded from?
What are all your settings in Admin->Configuration->Logging ?
Please check my attached image about that .
Also, i use 1.38a
In /includes/classes/db/mysql/query_factory.php, do your lines 86-100 match the following code?Code:function Execute($zf_sql, $zf_limit = false, $zf_cache = false, $zf_cachetime=0) {
// bof: collect database queries
if (defined('STORE_DB_TRANSACTIONS') && STORE_DB_TRANSACTIONS=='true') {
global $PHP_SELF, $box_id, $current_page_base;
if (strtoupper(substr($zf_sql,0,6))=='SELECT' /*&& strstr($zf_sql,'products_id')*/) {
$f=@fopen(DIR_FS_SQL_CACHE.'/query_selects_' . $current_page_base . '_' . time() . '.txt','a');
if ($f) {
fwrite($f, "\n\n" . 'I AM HERE ' . $current_page_base . /*zen_get_all_get_params() .*/ "\n" . 'sidebox: ' . $box_id . "\n\n" . "Explain \n" . $zf_sql.";\n\n");
fclose($f);
}
unset($f);
}
}
// eof: collect products_id queries
global $zc_cache;
That code :
I think it is same!PHP Code:
function Execute($zf_sql, $zf_limit = false, $zf_cache = false, $zf_cachetime=0) {
// bof: collect database queries
if (defined('STORE_DB_TRANSACTIONS') && STORE_DB_TRANSACTIONS=='true') {
global $PHP_SELF, $box_id, $current_page_base;
if (strtoupper(substr($zf_sql,0,6))=='SELECT' /*&& strstr($zf_sql,'products_id')*/) {
$f=@fopen(DIR_FS_SQL_CACHE.'/query_selects_' . $current_page_base . '_' . time() . '.txt','a');
if ($f) {
fwrite($f, "\n\n" . 'I AM HERE ' . $current_page_base . /*zen_get_all_get_params() .*/ "\n" . 'sidebox: ' . $box_id . "\n\n" . "Explain \n" . $zf_sql.";\n\n");
fclose($f);
}
unset($f);
}
}
// eof: collect products_id queries
global $zc_cache;