Page 1 of 1

inner join crash

Posted: 10.02.2010, 14:51
by Gorky
Hi! I'm using MySQL 5.0+Delphi7+ZEOSDBO-6.6.5-stable. The problem is when i'm trying to use inner join instead of left join on tables with amount count or records 90k and 240k, the program isn't responding and MySQL Server starts to use the whole processor time. I was testing both variants of query in mysql console, execution time was about 0.9sec with left join and inner join too. So i think that's zeos problem, isn't it?
And by the way, can you tell me, will zeos support StoredProc for MySQL?

Posted: 10.02.2010, 16:21
by Wild_Pointer
Gorky,

Please add SQLmonitor to your project to see what queries are being executed. That way you'll find the one responsible for your problem.