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

Robert,

   The FE is always an MDE and is 11MB in size. De BE is always een MDB
   which differs from 24 to 150 MB
   Generaly there are five users who are updating and entering data and
   about 2 users who only read data
   The FE is always local on the computers. The BE is always in f:
   \oop\oopdata.mdb
    Alle forms are showing a limited no of records and are never bounded to
   a table


Thanks Marcel





"Robert L. Stewart" <rl_stewart at highstream.net>@databaseadvisors.com op
20-10-2003 15:52:48

Antwoord aub aan Access Developers discussion and problem solving
      <accessd at databaseadvisors.com>

Verzonden door:     accessd-bounces at databaseadvisors.com


Aan:  accessd at databaseadvisors.com
cc:   marcel.vreuls at achmea.nl

Onderwerp:     [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


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


*****************************************************************
Dit bericht is bij binnenkomst gecontroleerd op de
aanwezigheid van virussen. Er zijn geen (bekende)
virussen gevonden.  Active
*****************************************************************






********************* DISCLAIMER *********************
De informatie in dit e-mail bericht is uitsluitend
bestemd voor de geadresseerde. Verstrekking aan
en gebruik door anderen is niet toegestaan.
Door de electronische verzending van het bericht
kunnen er geen rechten worden ontleend aan de
informatie.
************************************************************