MYSQL Query execution time

Question

HI I have a MYSQL Query which has a long response time. I have a table for_reg_users which has different fields like first name, last name and date visited. I run the query to get records which are new( i-e: before particular time period they do not have a entry and the record should be unique so the first name and last name is combined). Can this query be written in different way so that the response time is less. Thanks in advance.

Query = SELECT * FROM `for_reg_users` where `date_visited` BETWEEN '2012-05-01' AND '2012-05-31' AND CONCAT(first_name, ' ', last_name) NOT IN ( SELECT CONCAT(first_name, ' ', last_name) from `for_reg_users` where `date_visited` < '2012-05-01') AND `deleted` = '0';

Shehzad Bilal · Accepted Answer · 2012-06-14 09:22:02Z

1

Query = SELECT DISTINCT(CONCAT(first_name, ' ', last_name)) , * FROM `for_reg_users` where `date_visited` <= '2012-05-31' and deleted = 0

edited Jun 14, 2012 at 9:22

answered Jun 14, 2012 at 9:14

Shehzad Bilal

2,5132 gold badges19 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MYSQL Query execution time

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related