Mysql query taking long time when using variable

Asked Feb 26 '18 at 12:29

Active Feb 26 '18 at 12:33

Viewed 84 times

SET @acounts = 0;
SET @bcounts = 0;
SET @cur_year = '2015';
SET @userId = "m00087654";

SELECT *, (@acounts :=@acounts+1) as id FROM (
SELECT distinct  userId,cid  FROM `TABLE`
WHERE user_id = @userId AND ntype = 'parta'   AND date_from <>  date_to AND  YEAR(ndate) = @cur_year 
ORDER BY ndate, cid) AS a;

Time taken 1.22 sec

 SELECT *, (@acounts :=@acounts+1) as id FROM (
SELECT distinct  userId,cid  FROM `TABLE`
WHERE user_id = "m00087654" AND ntype = 'parta'   AND date_from <>  date_to AND  YEAR(ndate) = @cur_year 
ORDER BY ndate, cid) AS a;

Time taken 0.0022 sec

when i put user_id = @userId then it take more time comparing user_id = "m00087654"

Any clue why taking more time ?

asked Feb 26 '18 at 12:29

Samiul

What happens when you use `SET @cur_year = 2015;` (int instead of string)? – Psi Feb 26 '18 at 12:32
no differance for year. Only prob when using user_id = @userId – Samiul Feb 26 '18 at 12:39
only prob in user_id = @userId – Samiul Feb 26 '18 at 12:41

Mysql query taking long time when using variable

0 Answers0