[AccessD] Connections and Performance

Heh :) It took me a few minutes, but I found this 'explanation'
http://www.crystaltech.com/Newsletters/news2006-08tech.aspx

Access vs. MS SQL or MySQL
If you are utilizing a Microsoft Access database with your website,
one strong recommendation would be to change to SQL or MySQL.
Access uses a file server system approach where each user reads
and writes directly to the raw data tables, making it ideal for use as a
desktop solution at home.

However, Access is not optimized for use with a large number of
concurrent connections and does not scale for large databases. As more
users connect to an Access database, the performance starts to degrade
rapidly. Even moderately-trafficked websites can easily have 5 or more
users at one time which can cause Access to lock the number of connections.

MySQL and SQL, which utilize a more efficient client-server structure,
can support hundreds, even thousands of concurrent users for a much more
secure and stable level of performance. Since they can be configured to
effectively accommodate multiple users with a high level of uptime, 
reliability
and scalability that Access cannot offer, they are ideal for an online
production environment.

Michael R. Mattys
MapPoint & Access Dev
www.mattysconsulting.com

----- Original Message ----- 
From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Friday, February 02, 2007 9:46 AM
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