Hale, Jim
Jim.Hale at FleetPride.com
Thu Jul 5 11:41:15 CDT 2007
Is your network local, ie. the backend is on a server with a fast connection? No one has mentioned this but my experience has been anything outside the local office connecting to a backend on our network is unacceptably slow (I believe we have dedicated T1s, I'll find out from the notwork guy). Connecting through a VPN connection over the net is unacceptable for us even with broadband. My backends range from 100mg-400mg. Jim Hale -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Annie Courchesne, CMA Sent: Thursday, July 05, 2007 5:35 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Performance tips anyone? Hi all, Wow, lots of great tips! Any thoughts about having a dedicated server for the BE db only? The BE db is 650mb with 200 tables. The largest table 1.5 millions records. The FE db is split in two db, one with the forms and one with the report. The form db is 45mb with about 2000 objects. The report db is 14 mb with about 1000 objects. The report db as to be compacted regularly since it's using temp table and the size can grow to 500 mb depending of the report printed. Thanks! Annie Courchesne, CMA -----Message d'origine----- De : accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] De la part de Steve Schapel Envoyé : 5 juillet 2007 01:10 À : Access Developers discussion and problem solving Objet : Re: [AccessD] Performance tips anyone? Annie, If you have forms with lots of comboboxes, it certainly helps if you don't populate them unless and until they are needed, i.e. set the Row Source on their Enter event. Similarly, if you have forms with subforms on different pages of a tab control, leave the Source Object of the subforms blanks, and only set it if and when that tab is selected. And here's another thing I only found out about this week... the first time a saved query is run after the database is compacted, will be slow, because the query plan has to be re-created. So if you compact/repair the front-end application file, queries will run slow the first time, and forms based on queries will open slowly the first time. An argument against 'Compact On Close' - but then, for memory, I don't think Comapct On Close was available in Access 97. Regards Steve Annie Courchesne, CMA wrote: > 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 *********************************************************************** The information transmitted is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this email in error please contact the sender and delete the material from any computer. As a recipient of this email, you are responsible for screening its contents and the contents of any attachments for the presence of viruses. No liability is accepted for any damages caused by any virus transmitted by this email.