Jim Dettman
jimdettman at earthlink.net
Mon Oct 20 08:23:00 CDT 2003
Marcel,
Before moving to anything else, I'd try and squeeze some more performance
out of what you have. One of the big things you can do is to keep a
reference to the BE open at all times while the app is open. Some other
things:
0. For Windows servers, make sure OPLOCKS are turned off (see MSKB).
1. Make sure the MDB is not being virus scanned on the sever or client (some
are set to "scan on open").
2. Turn off Name Auto Correct.
3. Turn off sub data sheets.
4. Make sure your MDB is compiled and stays that way (alternatively
distribute the FE as a MDE).
5. Limit forms to a subset of the data. i.e. limit the recordset to a
single record. Don't bind forms to an entire table.
The first few are easy (along with the reference thing mentioned above)
and should yield a healthy boost in performance. Beyond that, moving to a
true client/server setup to limit data on the network is the way to go. But
you can get some good results by doing #5 above.
BTW for JET based solutions, DAO is as fast as you can get. Moving to ADO
only will actually slow things down.
Jim Dettman
President,
Online Computer Services of WNY, Inc.
(315) 699-3443
jimdettman at earthlink.net
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of
marcel.vreuls at achmea.nl
Sent: Monday, October 20, 2003 7:37 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Performance ADO - DAO or ??
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
"dave sharpe" <davesharpe2 at cox.net>@databaseadvisors.com op 19-10-2003
06:32:54
Antwoord aub aan Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Verzonden door: accessd-bounces at databaseadvisors.com
Aan: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
cc:
Onderwerp: Re: [AccessD] ado recordcount
John - This article may be of benefit
Dave
PRB: ADO: Recordcount May Return -1
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:
80/support/kb/articles/q194/9/73.asp&NoWebContent=1
----- Original Message -----
From: "John Colby" <jcolby at colbyconsulting.com>
To: "AccessD" <AccessD at databaseadvisors.com>
Sent: Saturday, October 18, 2003 11:38 PM
Subject: [AccessD] ado recordcount
I am opening a recordset (raw table) that contains records.
Move last, move first.
EOF and BOF are both false.
Recordcount = -1
What gives? How do I tell how many records in the recordset?
John W. Colby
www.colbyconsulting.com
_______________________________________________
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
*****************************************************************
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.
************************************************************
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com