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

Robert,

Thanks. I will install MSDE and keep you and the group posted about my
findings.

Gr. marcel




"Robert L. Stewart" <rl_stewart at highstream.net>@databaseadvisors.com op
22-10-2003 17:56:34

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,

Looks like you are doing everything right.

Since you are using 2000, I would explore using
the MSDE for the backend.  You would be fine on
the number of users it is designed for.  Then I
would convert everything to an ADP and use ADO.
I have found that on one of my large forms, 8
subforms with 2 sub-subforms, in MDE it loaded
in about 15 seconds, in ADP < 2 seconds.

Sorry that I cannot give you any more advise than
that.

Robert

At 08:45 AM 10/22/2003 -0500, you wrote:
>Date: Tue, 21 Oct 2003 10:50:25 +0200
>From: marcel.vreuls at achmea.nl
>Subject: Betreft: [AccessD] Re: Performance ADO - DAO or ??
>To: Access Developers discussion and problem solving
>         <accessd at databaseadvisors.com>
>Message-ID: <OFBDBE24B3.31190D20-ONC1256DC6.00304900 at achmea.nl>
>Content-Type: text/plain; charset=iso-8859-1
>
>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


_______________________________________________
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.
************************************************************