MySql hangs when trying to query table with many records (PHP)

0

I'm trying to make a filter where the query is done in a table where the id of the last record is in the number 468.466 .

In the filter, I need to compare with a View, which has its last record id 5,303,345 .

The query is as follows:

SELECT * FROM tb_name1
left join tb_name2 using (id)

When trying to do it, it takes a long time to load and does not finish, because until it locks up my whole computer, I need to restart it on the button.

Any solution for me to be able to run this filter?

    
asked by anonymous 27.08.2018 / 14:13

0 answers