LibMySQL.dll and Lost connections during Query
I have the same problem. Before I connected to MySQL with BDEODBC and everything was fine. But when I've converted my project to MyDAC, I get this error very often. In some cases the error doesn't appear every time and there are situations when it appears always. For example, there is a query where about 25-30 tables joined each to other, if the select command doesn't contain "straight_join" then MySQL optimizer thinks slow even if all tables in select are empty. But using MyODBC I didn't get "lost connection". Why?
P.S. Sorry for bad english...
P.S. Sorry for bad english...
Please describe the situation more detailed:
1. What is the exact MyDAC version that you use?
2. Do you use compression (MyConnection.Options.Compress)?
3. How much time does it take to execute the query?
4. Does it help increasing CommandTimeout?
5. Does it help setting MyConnection.Options.Direct := False?
1. What is the exact MyDAC version that you use?
2. Do you use compression (MyConnection.Options.Compress)?
3. How much time does it take to execute the query?
4. Does it help increasing CommandTimeout?
5. Does it help setting MyConnection.Options.Direct := False?