Performance queries con múltiples JOIN.

[Carlangueitor]

Gracias! Efectivamente trabaja mucho más rápido, tarda ~20s, lo cuál tampoco es muy aceptable. Pero me di cuenta (por mi poco conocimiento en bases de datos y SQL) de otra manera de hacerlo.

Código MySQL:

SELECT 
    auctions_flight.id,
    auctions_flight.date,
    destinations.code as destination_code,
    destinations.name as destination,
    MAX(auctions_flight.num_seating) as num_seating,
    auctions_flightprice.Price,
    MIN(auctions_flightprice.Price) as price
FROM
    auctions_flight
        INNER JOIN
    auctions_flightprice ON auctions_flight.price_id = auctions_flightprice.id
        INNER JOIN
    locations_location AS origins ON auctions_flight.origin_location_id = origins.id
        INNER JOIN
    locations_location AS destinations ON auctions_flight.destination_location_id = destinations.id
WHERE
    auctions_flight.num_seating >= 3
        AND auctions_flight.price_id IS NOT NULL
        AND auctions_flightprice.currency = 'MXN'
        AND origins.code = 'MEX'
        AND auctions_flight.date >= CURDATE()
GROUP BY auctions_flight.date , auctions_flight.destination_location_id , auctions_flight.origin_location_id
ORDER BY price , auctions_flight.date
LIMIT 0 , 25;
 

Y hasta ahora funciona adecuadamente y a buen tiempo ~0.1s.


Saludos