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?