Using multiple databases

[berbbrown]

Hi All

Hope you can provide some advice. I have searched the PHPBuilder forums for an answer and just wanted to know what the definitive answer would be to my question.

I have three MySQL databases and I wish to connect to all three sometimes at the same time. How do I open three separate connections to the databases?

I have noticed that some threads mention ADODB. Is this faster than the traditional method in connecting to a MySQL database?

Thanks in advance.

BB

[laserlight]

I have three MySQL databases and I wish to connect to all three sometimes at the same time. How do I open three separate connections to the databases?

It depends on your database API. For example, with the PDO extension you would create a PDO object for each database connection. Likewise, with the MySQLi extension you would create a MySQLi object for each database connection. With the legacy MySQL extension you would have a different link identifier for each database connection.

I have noticed that some threads mention ADODB. Is this faster than the traditional method in connecting to a MySQL database?

No, it is an abstraction layer and thus may even result in slightly lower performance as a trade off.

[MarkR]

berbbrown wrote:

I have three MySQL databases and I wish to connect to all three sometimes at the same time. How do I open three separate connections to the databases?

Trivially. The same as you would one. Just make sure you specify a link_id if you're using the mysql_ functions.

I have noticed that some threads mention ADODB. Is this faster than the traditional method in connecting to a MySQL database?

No, it's just a wrapper which confers no advantage. In fact it would probably be slower (but not by enough that you care)

Mark