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