multiple database performance

[Howard]

I have a page that pulls data from 4-5 different databases on the same
server. Is there going to be any performance problems that I should be aware
of?

Thanks,
Howard

 

[Guest]

Hi Howard,

Connecting to database will always add a overhead to the application. The
best we can do is to follow Best Practices and minimize the overhead. There
are lots you can find on this like connection pooling (use same connection
string for each database and runtime will manage connection pooling), open
connection late and close connection early so that connection pooling is best
used.

Augustin