Hello!
Again we've some problems with your lib. Inserting of binary data results in
- "Net packets out of order: received[2], expected[3]" exceptions on an intranet server
or in
- "Lost connection to MySQL server during query" exceptions on a local server
It helps to close and open the connection with EVERY record (we use parameters) - That can not be the real solution for this problem... Also the non-direct mode (libmysql) is a solution. The max_allowed_packets is high enough, we use a 5.0 server and all other tools work with this binary files.
We are a little bit displeased with your software. It's slower than the original connector and there are to many bugs, when you are a heavy user of the lib. I hope you can quickly find a solution for this...
Regards,
Sven Kolber
Net packets out of order / Connection closed during query
1. Do you use Prepare method or non-direct mode (Direct=false)?"Net packets out of order: received[2], expected[3]" exceptions on an intranet server
2. Make sure you close all data readers explicitly.
3. If you use Prepare() method of MySqlCommand class, call Dispose() after closing reader.
4. If you use connection pooling, call MySqlConnection.Ping() method before MySqlConnection.Open().
5. If above doesn't help and you use connection pooling, check if you can turn connection pooling off.
Please inform us whether our instructions helped you and which one solved the problem.
According to our performance tests results, MySQLDirect .NET is no worse than Connector/NET provider by MySQL AB.We are a little bit displeased with your software. It's slower than the original connector
If you have an example of dramatic difference in speed, please send it to the address provided in the Readme file.
Describe in detail all the bugs you are complaining about.there are too many bugs
Last edited by Alexey on Fri 03 Nov 2006 16:11, edited 2 times in total.