wikioo.org - Optimize SQL queries and PHP for speed

This is for expert only we would like to optimize [login to view URL] for speed by checking all SQL queries and optimizing SQL and PHP There is few issues with speed, but it is necessary to review and check every query, and every tables There is one or two day of work maximum for a real expert. Server is running LINUX and PHP ÄPACHE and have also WEBMIN PHPMYADMIN FTP task : - create all indexes (all columns used in any WHERE) - Review data type in all columns and in PHP (to match and avoid conversions) : --- to use INT only for the painting date and for artist date and for artist ranking and for painting ranking --- VARCHAR for everything --- TEXT for : painting description , artist biography , painting title , url please check everything and give recommendations Try to Remove all LIKE '%hello%'; in the WHERE Try to remove : NOT LIKE, NOT IN, NOT EXIST Try to Remove : WHERE substr ( COLUMN, 1, 1 ) = 'value'. All WHERE must be simple = < >