id	summary	reporter	owner	description	type	status	priority	milestone	component	version	resolution	keywords	cc	blockedby	blocking
2001	unnötiger Code - new_attributes.php	Volker Strähle		"In admin/includes_module/new_attributes.php findet sich auf ca. Zeile 200 folgender Code:


{{{
                // Lets get all of the possible options
                $query = ""SELECT *
                            FROM "".TABLE_PRODUCTS_OPTIONS.""
                           WHERE products_options_id LIKE '%'
                             AND language_id = '"" . (int)$_SESSION['languages_id'] . ""'
                        ORDER BY "". $option_order_by;

}}}

products_options_id LIKE '%' ist unnötig und führt zu einem langsammen tablescan.
"	Bug/Fehler	new	normal	DB-Performance	Module	trunk