1
I have a query that does the inner join of heavy tables with the filter where coluna = 'valor da coluna', runs until reasonable but would need to run this query without the filter. Only the query loaded until it lost the server connection.
Searching, I found a function ignore index and use index, with the ignore index, be able to at least bring the information, although it is still taking a little while but so far so good.
My problem now is that in this query, I need to do a group_concat with two columns, the query loads again and again. Without this group_concat normal wheel.
Does anyone know a way to make the query run with ignore index and the group_concat?
My query looks something like this:
select
coluna1,
coluna2,
group_concat(distinct(concat(subject_id,',',subject_value)), '') as valor,
coluna 3,
time_update
from
tabela1 as a straight_join tabela2 as b on a.columa1 = b.coluna2
straight_join tabela3 as c on b.coluna2 = c.coluna3 where
date_format(c.time_update,'%Y-%m-%d') >= date_format(date_add(curdate(), interval -3 day), '%Y-%m-%d');