I have a web server that gets the information from the SQL database, but when I search it is real slow. I am using this sql statement.
SELECT dbo_Machine.MachineID, dbo_Pool.PoolPath, dbo_Machine.Name, dbo_Machine.Notes, dbo_Machine.AssetNumber, dbo_Machine.Manufacturer, dbo_Machine.Model, dbo_Machine.CPUType, dbo_Machine.CPUSpeed, dbo_Machine.CPUCount, dbo_Machine.TotalRAM, dbo_Machine.DiskCount, dbo_Machine.NetCardCount, dbo_Machine.CheckOut, dbo_Machine.CheckOutDate, dbo_Machine.EstimatedTime, dbo_Machine.Processed, dbo_Machine.NotifyStatus, dbo_Machine.LastActivity, dbo_Machine.PoolId, dbo_Machine.Status, dbo_Machine.MACAddress, dbo_Machine.Type, dbo_Machine.CompanyId, dbo_Machine.BuildingId, dbo_Machine.RoomId, dbo_Machine.RackId, dbo_Machine.SerialNumber, dbo_Machine.MachineKey, dbo_Machine.OS, dbo_Machine.PrimaryIP, dbo_Machine.Published, dbo_Machine.Subscribed, dbo_Machine.Subscriber, dbo_Machine.Expiration, dbo_Machine.Unsubscribed, dbo_Machine.Deleted, dbo_Machine.ServerRole, dbo_Machine.DeletedDate, dbo_Machine.PO, dbo_Machine.LastHeartbeat, dbo_Machine.CoreCount, dbo_Building.BuildingName, dbo_Room.RoomName, dbo_Rack.RackName FROM (dbo.Machine dbo_Machine INNER JOIN dbo.Building dbo_Building ON (dbo_Building.BuildingId = dbo_Machine.BuildingId) INNER JOIN dbo.Room dbo_Room ON (dbo_Room.RoomId = dbo_Machine.RoomId) INNER JOIN dbo.Rack dbo_Rack ON (dbo_Rack.RackId = dbo_Machine.RackId) INNER JOIN dbo.Pool dbo_Pool ON (dbo_Pool.PoolId = dbo_Machine.PoolId))
Any help would be helpful
SELECT dbo_Machine.MachineID, dbo_Pool.PoolPath, dbo_Machine.Name, dbo_Machine.Notes, dbo_Machine.AssetNumber, dbo_Machine.Manufacturer, dbo_Machine.Model, dbo_Machine.CPUType, dbo_Machine.CPUSpeed, dbo_Machine.CPUCount, dbo_Machine.TotalRAM, dbo_Machine.DiskCount, dbo_Machine.NetCardCount, dbo_Machine.CheckOut, dbo_Machine.CheckOutDate, dbo_Machine.EstimatedTime, dbo_Machine.Processed, dbo_Machine.NotifyStatus, dbo_Machine.LastActivity, dbo_Machine.PoolId, dbo_Machine.Status, dbo_Machine.MACAddress, dbo_Machine.Type, dbo_Machine.CompanyId, dbo_Machine.BuildingId, dbo_Machine.RoomId, dbo_Machine.RackId, dbo_Machine.SerialNumber, dbo_Machine.MachineKey, dbo_Machine.OS, dbo_Machine.PrimaryIP, dbo_Machine.Published, dbo_Machine.Subscribed, dbo_Machine.Subscriber, dbo_Machine.Expiration, dbo_Machine.Unsubscribed, dbo_Machine.Deleted, dbo_Machine.ServerRole, dbo_Machine.DeletedDate, dbo_Machine.PO, dbo_Machine.LastHeartbeat, dbo_Machine.CoreCount, dbo_Building.BuildingName, dbo_Room.RoomName, dbo_Rack.RackName FROM (dbo.Machine dbo_Machine INNER JOIN dbo.Building dbo_Building ON (dbo_Building.BuildingId = dbo_Machine.BuildingId) INNER JOIN dbo.Room dbo_Room ON (dbo_Room.RoomId = dbo_Machine.RoomId) INNER JOIN dbo.Rack dbo_Rack ON (dbo_Rack.RackId = dbo_Machine.RackId) INNER JOIN dbo.Pool dbo_Pool ON (dbo_Pool.PoolId = dbo_Machine.PoolId))
Any help would be helpful
Comment