[AccessD] Re: Performance ADO - DAO or ??

Marcel,

How big is the FE and BE databases?

How many simultaneous users?

Are the users using a local copy of the FE?

Do your forms limit the number of records displayed?

After getting the answers to these questions, I can
give you better direction.

Robert

At 08:23 AM 10/20/2003 -0500, you wrote:
>Date: Mon, 20 Oct 2003 13:37:29 +0200
>From: marcel.vreuls at achmea.nl
>Subject: [AccessD] Performance ADO - DAO or ??
>To: Access Developers discussion and problem solving
>         <accessd at databaseadvisors.com>
>Message-ID: <OFEC1AA300.2EAE21EC-ONC1256DC5.003F2FED at achmea.nl>
>Content-Type: text/plain; charset=iso-8859-1
>
>Dear group,
>
>It has been a while since I looked into this group. My daughter (7 months)
>took up most of my time recently. But work goes on so I would like to ask
>you the following.
>
>I am strugling with the following. I have about 6 access 2000 applications
>distributed among several customers. All database use DAO and have a FE and
>BE. It works fine but know customers start complaining about performance.
>Expecially on a network envirnement.
>I have
>  - Looked through all the queries and changed all the SELECT *  queries
>with only the data wich is used
>- closed all recordset and database connection at the end of eacht function
>of module.
>-  Removed databound forms as much as possible. This is a lot of work and I
>do not know if i want to do this.
>
>But this all did not improved much.
>
>I am thinking about the following
>- Is it a option to move to ADO instead of DAO. Does this improve
>performance?. In my tests it does not matter much but perhaps I am missing
>something
>- The performance analyser in Access tells me to use fewer controls on a
>form. If I do this does this improve performance
>- moving to sql server. But this will cost my customer a lot of money and
>the won´t be happy.
>
>
>Any suggestions, ideas??
>I am thinking to rewrite the programms to VB, anyone experience, tips,
>tricks in this.
>
>Thansk marcel