Sorry this isn’t about Lucee directly, but this has be scratching my head
to get fixed.
I run the following query.
select Universe_Planets.Name
, Universe_Planets.PlanetID
, Universe_Planets.LocationX
, Universe_Planets.LocationY
, (Select X from Universe_Planets_Map where PlanetID = 258 Order by X Desc
Limit 1) as SizeX
, (Select Y from Universe_Planets_Map where PlanetID = 258 Order by Y Desc
Limit 1) as SizeY
, Universe_Planets_Map.LocationID
, Universe_Planets_Map.X
, Universe_Planets_Map.Y
, Universe_Planets_Map.RaceID
, Universe_Planets_Map.Facility
, Universe_Planets_Map.Terrain
, Universe_Planets_Map.Steel
, Universe_Planets_Map.Coal
, Universe_Planets_Map.Uranium
, Universe_Planets_Map.Wood
, Universe_Planets_Map.Sand
, Universe_Planets_Map.Plant
, Universe_Planets_Map.Gold
, Universe_Planets_Map.Leather
, Universe_Planets_Map.Meat
, Universe_Planets_Map.Human
, Universe_Planets_Map.Zurna
, Universe_Planets_Map.Davul
, Universe_Planets_Map.Santoor
, Universe_Planets_Map.Udu
, Universe_Planets_Map.Swarm
from Universe_Planets
, Universe_Planets_Map
where Universe_Planets.PlanetID = 258
and Universe_Planets.PlanetID = Universe_Planets_Map.PlanetID
and Universe_Planets_Map.X in (17,18,19)
and Universe_Planets_Map.Y in (17,18,19)
Order by Universe_Planets_Map.X
, Universe_Planets_Map.Y
I have X and Y indexed… But for some reason, this thing takes 1 min. to
return a result of 9 records.
Can anyone help with why this is taking so long?