Hi KK
Recently, our webserver hang because every singe request to CouchCMS produces a sql data transfer as large as about 400 MB.
Digging into the code we found a code fetching the whole table 'couch_settings' in couch/functions.php on line 2320:
Looking at the datatable 'couch_settings', it has a size of 559 MiB (phpMyAdmin).
This is a severe problem we were slipping in, so any quick help is highly appreciated.
Regards,
Olliwalli
Recently, our webserver hang because every singe request to CouchCMS produces a sql data transfer as large as about 400 MB.
Digging into the code we found a code fetching the whole table 'couch_settings' in couch/functions.php on line 2320:
- Code: Select all
$rs = @mysql_query( 'select * from '.K_TBL_SETTINGS, $DB->conn );
Looking at the datatable 'couch_settings', it has a size of 559 MiB (phpMyAdmin).
- - What ist this table for?
- Can I reduce its size?
- If yes, how?
This is a severe problem we were slipping in, so any quick help is highly appreciated.
Regards,
Olliwalli