[AccessD] Connections and Performance

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