Erwin Craps - IT Helps
Erwin.Craps at ithelps.eu
Mon Feb 5 03:25:52 CST 2007
Did you checked that the virusscanner don't scan mdb? Ik had a bizare problem with a McAfee virusscanner that when eacht time saving a record it pauzed for 2 to 10 seconds. When turning the scanner off it was instant. The client now doesnt use a virusscanner temproraraly, until I get there to find the issue. Erwin -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Ervin Brindza Sent: Monday, February 05, 2007 9:32 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Connections and Performance Dan, how about using temporary tables for adding new records and for reporting? Ervin ----- Original Message ----- From: "Dan Waters" <dwaters at usinternet.com> To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Sent: Saturday, February 03, 2007 5:12 AM Subject: Re: [AccessD] Connections and Performance > Drew, > > I read this somewhere - either in MS documentation or in a book where I > believe the author. > > Here's the reason I was asking: > > At a certain customer site, they experienced a dramatic performance > slowdown > at a time when about 10 people were logged on concurrently. Each client > PC > has it's own FE. I know that they open the system and leave the process > screens open, all of which are bound. I want to suggest that they > remember > to close the process screens so that just the main screen is open, which > is > not bound. This way a fewer number of connections are being used at any > one > time and performance would probably be acceptable. This particular > customer, I believe, does not have a very good network, so that is part of > the problem. But that's unlikely to get improved, so I wanted to provide > at > least a partial solution, hence my question. > > I've also heard that a connection is made not based on whether a form is > open and bound, but on whether or not there is data traffic between to and > from a table, which only takes a small part of a second. > > So what causes the performance slowdown when only 10 client PC's are > logged > on, and what could be done to improve this? > > Dan Waters > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka > Sent: Friday, February 02, 2007 9:26 AM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Connections and Performance > > Where are you getting these numbers. Access can have up to 255 > connections. > > Drew > > -----Original Message----- > From: Dan Waters [mailto:dwaters at usinternet.com] > Sent: Friday, February 02, 2007 8:45 AM > To: 'Access Developers discussion and problem solving' > Subject: Re: [AccessD] Connections and Performance > > Access has the potential for 8 simultaneous connections, but 3 of them are > reserved for the system's use. That leaves five for users. > > Dan Waters > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of JWColby > Sent: Friday, February 02, 2007 8:02 AM > To: 'Access Developers discussion and problem solving' > Subject: Re: [AccessD] Connections and Performance > >>But, the connection limit for one BE is 5 FE's. > > What does this mean? I have never heard of any such 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 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 > > -- > 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 > > -- > 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 > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > > -- > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.5.432 / Virus Database: 268.17.19/663 - Release Date: 2/1/2007 > 2:28 PM > > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com