CODEWITHSUNDEEP
mysqldelphidelphi-xe2
Ago
Ago

Reputation: 765

Effect of Multiple TADOConnection

What is the effect of multiple tadoconnection? Here is what I did :

  1. I put a TADOConnection to almost every form in my application.
  2. Those TADOConnection will connect to the database(MySQL) everytime I create an instance of a form.

In an average use of the application, about 15 forms will be used(15 tadoconnections connected to the database). So far my application is running smooth. But yesterday, a user complained of an error "MySQL has gone away". I've encountered that error in the past and it was because the data is too large, or hardware problem. But today, the data is not big and the hardware is in excellent condition. By the way, the connection is local. Does the multiple tadoconnection produced the error?

Upvotes: 0

Views: 152

Answers (1)

deterministicFail
deterministicFail

Reputation: 1285

The effect of multiple ADOConnections is that you, open multiple independent Session in the Database. I wouldnt recommend your solution, in consideration of Transactionmanagement and table locking

Server has gone away: http://dev.mysql.com/doc/refman/5.1/en/gone-away.html

Upvotes: 1

Related Questions