The driver we use for connecting to the database is MySQLDriverCS which can be found at http://sourceforge.n.../mysqldrivercs/
Here comes the problem. We have to recalculte some values for 2500+ invoices. To do this calculation not only we have to obtain the invoice details from the db but also the products associated to it, which are 25+ SELECT statements for every invoice.
We thought that MYSQL db and the driver could handle this but i guess we were wrong. Every time after proccesing not more than 20 invoices the connection to the database closes and when its tryed to be reopened an exception saying " MySQLDriverCS Exception: MySQLDriverCS Error: can't connect.Can't connect to MySQL server on 'localhost' (10060) " is thrown.
MySQL Administrator shows that around 170 queries are being exceuted at a time.
Could this error be due to server flooding?
Is there any way to fix this?
Is MySQL capable of handling this kind of load?
We have some doubts about the driver we use. Does anyone recommend another driver?.
Any help is greatly appreciated.