[AccessD] Connections and Performance

LOL< yea but there is so much external to the database (networks, server
speed etc.).  

But yea, and that is why I say the same thing. 


John W. Colby
Colby Consulting
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Friday, February 02, 2007 9:58 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Connections and Performance

It doesn't seem any faster when only a couple of people are using it :-)

On 2 Feb 2007 at 9:51, JWColby wrote:

> Likewise, though how do you tell???? 
> 
> 
> John W. Colby
> Colby Consulting
> www.ColbyConsulting.com
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart 
> McLachlan
> Sent: Friday, February 02, 2007 9:47 AM To: Access Developers 
> discussion and problem solving Subject: Re: [AccessD] Connections and 
> Performance
> 
> ? 
> I regularly run apps with up to 30 FEs accessing the BE with no 
> performance degradation.
> 
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan 
> > Waters
> > Sent: Friday, February 02, 2007 8:58 AM To: 'Access Developers 
> > discussion and problem solving' Subject: [AccessD] Connections and 
> > Performance
> > 
> > I've read several times that maintaining a connection between a FE 
> > and a BE will increase the performance of the FE because it doesn't 
> > need to reconnect before transferring data.  The connection here 
> > would be a bound form connected by a table link to a table in the BE.
> > 
> > But, the connection limit for one BE is 5 FE's.  So, will 
> > maintaining connections on more than 5 FE's reduce performance?  
> > Seems logical, but I was wondering if this is correct or is there more
to it?
> > 
> > Thanks!
> > 
> > Dan Waters
> --
> Stuart
> 
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

--
Stuart


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com