Hay
PHP Code optimization required.
Website URL : [login to view URL]
Recent Searches taking alot database usages, some filter code use in database function.
$res = db_ExtQuery ( $dblink, "SELECT * FROM `#_searches` WHERE search NOT LIKE('%www.%') && search NOT LIKE('%amp%') && search NOT LIKE('%http%') && search NOT LIKE('%.com%') && search NOT LIKE('%quot%') && search NOT LIKE('%alt%') && search NOT LIKE('%#%') && search NOT LIKE('%//%') && search NOT LIKE('%&%') ORDER BY `added` DESC LIMIT {$limit}" );
We want to change current code to PHP trim() or PHP str_replace Functions.
Also safe recent searches from Meta refresh code (reduction to other website).