Streamline SQL Query with DataTables

0

The query below returns a DataTables with approximately 400 items in the Mysql database. The difficulty is to return these values more quickly. It currently takes an average of 70 seconds to display the list completely. It's a low number of items even so there is a big delay. Is it possible to improve performance through SELECT ?

SELECT 
   p.*,
   pc.*,
   u.name as autor, u.surname
FROM 
    'product' p
INNER JOIN
    'product_config' pc ON p.id = pc.id_product
LEFT JOIN
    'users' u ON u.id = p.idAutor
ORDER BY 
    p.id DESC 
    
asked by anonymous 08.12.2016 / 05:25

0 answers