Hi everyone, I love HeidiSQL since a long time. But my love story began to change since I have started to face issue with the executing time of my queries...
My query has this face : SELECT * FROM table_1 T1 JOIN table_2 T2 ON T2.A=T1.A
Very simple query to explain my issue. table_1 has approximately 79k rows and table_2 has 128k. More than 20min to get the final result. That's ridiculous.
I have found that is the fetching time that is exploding.
I also tried on mysql but same story. The weirdest point is that for a similar query made on oldest tables and much bigger, the executing time is lower. All the data are stored in a local server.
I would be glad if some of you can help me. I have already searched on the web but I didn't find any solution.
Thank you for your help. :)