MySQL Query Takes Too Long.
This query runs quickly in MSSQL, however extremely slow in MySQL. Help!
INSERT INTO Archives (DateIn, `Priority`
(SELECT DateIn, `Priority`
FROM Logs s
JOIN Ports p on p.Port = s.Port And p.Secured = '1'
Where Not Exists (Select DateIn From Users Where DateIn = s.DateIn))
-- or --
Where DateIn Not In (Select DateIn From Users))
INSERT INTO Archives (DateIn, `Priority`
(SELECT DateIn, `Priority`
FROM Logs s
JOIN Ports p on p.Port = s.Port And p.Secured = '1'
Where Not Exists (Select DateIn From Users Where DateIn = s.DateIn))
-- or --
Where DateIn Not In (Select DateIn From Users))
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER