This is my SQL statement, but even to find 1 machine it takes to long. So people are complaining about it. This is the statement I use in my grid. Is there a way to speed this up???
I am displaying all of the records.
SELECT FIRST 50 MachineWithDeleted.MachineID, MachineWithDeleted.Name, MachineWithDeleted.AssetNumber, MachineWithDeleted.Manufacturer, MachineWithDeleted.Model, MachineWithDeleted.TotalRAM, MachineWithDeleted.Status, MachineWithDeleted.Type, MachineWithDeleted.BuildingId, MachineWithDeleted.RoomId, MachineWithDeleted.RackId, MachineWithDeleted.Deleted, MachineWithDeleted.LastHeartbeat, Building.BuildingName, Room.RoomName, Rack.RackName, MachineWithDeleted.Deleted AS Deleted1, Pool.PoolName, Pool.PoolPath, MachineProperty.PropertyName, MachineProperty.PropertyValue
FROM (MachineWithDeleted MachineWithDeleted
LEFT OUTER JOIN Building Building
ON (Building.BuildingId = MachineWithDeleted.BuildingId)
LEFT OUTER JOIN Room Room
ON (Room.RoomId = MachineWithDeleted.RoomId)
LEFT OUTER JOIN Rack Rack
ON (Rack.RackId = MachineWithDeleted.RackId)
LEFT OUTER JOIN Pool Pool
ON (MachineWithDeleted.PoolId = Pool.PoolId)
LEFT OUTER JOIN MachineProperty MachineProperty
ON ((MachineProperty.MachineID = MachineWithDeleted.MachineID) AND (propertyname = 'VMHost')))
ORDER BY MachineWithDeleted.Name, MachineWithDeleted.AssetNumber
I am displaying all of the records.
SELECT FIRST 50 MachineWithDeleted.MachineID, MachineWithDeleted.Name, MachineWithDeleted.AssetNumber, MachineWithDeleted.Manufacturer, MachineWithDeleted.Model, MachineWithDeleted.TotalRAM, MachineWithDeleted.Status, MachineWithDeleted.Type, MachineWithDeleted.BuildingId, MachineWithDeleted.RoomId, MachineWithDeleted.RackId, MachineWithDeleted.Deleted, MachineWithDeleted.LastHeartbeat, Building.BuildingName, Room.RoomName, Rack.RackName, MachineWithDeleted.Deleted AS Deleted1, Pool.PoolName, Pool.PoolPath, MachineProperty.PropertyName, MachineProperty.PropertyValue
FROM (MachineWithDeleted MachineWithDeleted
LEFT OUTER JOIN Building Building
ON (Building.BuildingId = MachineWithDeleted.BuildingId)
LEFT OUTER JOIN Room Room
ON (Room.RoomId = MachineWithDeleted.RoomId)
LEFT OUTER JOIN Rack Rack
ON (Rack.RackId = MachineWithDeleted.RackId)
LEFT OUTER JOIN Pool Pool
ON (MachineWithDeleted.PoolId = Pool.PoolId)
LEFT OUTER JOIN MachineProperty MachineProperty
ON ((MachineProperty.MachineID = MachineWithDeleted.MachineID) AND (propertyname = 'VMHost')))
ORDER BY MachineWithDeleted.Name, MachineWithDeleted.AssetNumber
Comment