jwcolby
jwcolby at colbyconsulting.com
Wed Jul 4 18:52:18 CDT 2007
If you are not doing so yet, the biggest single thing that you can do is keep a pointer to a table in the BE open. You can do that by opening a table, query or form based on a table etc. Doesn't matter how you do it but keep a pointer open. What happens is that the first time a table in the BE is used, JET has to acquire locks on the BE which takes longer and longer as more and more users are in the database. Once that first lock is acquired however, the next usage of the BE is much faster. Thus keeping some table open to the BE establishes that first lock and then keeps it open. 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 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