[thelist] multiple simultaneous db connections with classic ASP

[Ken Schaefer]

-----Original Message-----
From: thelist-bounces at lists.evolt.org
[mailto:thelist-bounces at lists.evolt.org] On Behalf Of Canfield, Joel
Subject: Re: [thelist] multiple simultaneous db connections with classic ASP

:> > Is using multiple simultaneous db connections as simple as creating
:> > multiple connections sorta like this
:> 
:> yeah, it may not be the most efficient method, but its what I do.
:
:Okay; helpful info. But then, what *might* be the most efficient method?
:Part of the reason for the recoding effort I'm making is that for the
:first time ever we're seeing performance issues on the tools I've built,
:and I fear it's my self-taught-inefficient methods, at least in part.

If these are separate databases, hosted/managed by separate DBMSes, then I
don't think you'll find a more efficient way of managing connection objects.

Have you done some profiling to determine where the bottleneck is occurring?

Cheers
Ken