jwcolby
jwcolby at colbyconsulting.com
Thu Jul 5 09:09:14 CDT 2007
Wow, this thread needs to be distilled and placed up on our site as a "how to". There have been a lot of good suggestions here. I actually ran into the virus checker thing a few years back and spent an hour or two tracking it down, but did I remember that for this thread? 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 Jim Dettman Sent: Thursday, July 05, 2007 10:03 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Performance tips anyone? Annie, Besides keeping a pointer open to the BE at all times, which John already mentioned: 1. Make sure that the MDB/MDEs are not being virus scanned on the clients and server. 2. If a NT/2000/2003 server is used to share the backend, consider turning off OPLOCKS (opportunistic locking). 3. Make sure the backend is only a level or two deep in the directory structure and access via a drive letter rather then UNC naming convention. I think everything else has already been mentioned. At the application level, Indexing of course is critical. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Annie Courchesne, CMA Sent: Wednesday, July 04, 2007 7:08 PM To: accessd at databaseadvisors.com Subject: [AccessD] Performance tips anyone? Hi all, I have a customer that complains about his database (BE/FE A97 running in runtime mode) is slow. The number of concurrent user keep growing over the years and it's up to 10 or 12 now. What I'm looking at right now is to optimize the whole database and upgrade to Access 2003. I've look at the performance tips from this page (http://www.granite.ab.ca/access/performancefaq.htm) and I've found some pretty usefull information. Anyone has other tips on getting this database more performing? I was also wondering if using a dedicated server for the database would help to improve performance? And what about SQL Server 2005 Express? I've read here that it's free and has a large capacity (more than enough for what I need). Will it really help in speeding up the database? How hard is it to set up? Any good documentation I can read on this? Thanks to all of you! Annie Courchesne, CMA -- 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