[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