[AccessD] Terrible performance like I have never seen before

Jim Lawrence accessd at shaw.ca
Wed Jul 7 21:43:12 CDT 2010


I have heard your story before and have held a couple of clients back from
upgrading until I can transfer their BE to MS SQL or SQL Express. The last
app that I migrated from a MDB BE to SQL Express, took about a month, in
dribs and drabs, to re-write, with SPs and using ADO-OLE connection. (Real
men and women do not use ODBC so we will not use that four letter euphemism,
in polite company, again.) ;-)

The new app now runs about twice as fast as the old 2003 FE/BE even using
the retarded Access2007 FE. This fall or early spring I will be moving the
FE to .Net and that will be an end to it.

Jim



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Breen
Sent: Wednesday, July 07, 2010 1:01 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Terrible performance like I have never seen before

Hello AccessD Friends of Old,

I have a customer that is running an large-ish access app.  About 50 tables
and 10 forms.  Some large complex queries.

One a standalone machine it runs fast as lightening.  They say that in the
past it also ran fast on their network.  However, they say that since they
upgrade the backend and front end to Access 2007, the performance has
dropped through the floor.

I can see the performance and it is absolutely terrible 30 - 60 seconds to
open a form.  But now for the interesting bit.  It is only slow when the 26
users are using it !!!  yes, they have 26 users keying data all day long.  I
was gobsmacked because while I read about it, I never saw it happening in
real life.

To Summarise,
26 users - Access 2000 no problem
26 users - Access 2007 dreadfully slow
1 users - Access 2007 no problem.

This is pointing to a difference between Access 2007 and multi-user
situations but how can I resolve it?

I have prepared an mdb file in Access 2000 format for testing when the 26
people come into work in the morning, and if downgrading the BE fixes it,
that I am happy, but I do not think it is going to solve my problems.

Any idea?

thanks for your help

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




More information about the AccessD mailing list