linking after update very slow (1 Viewer)

Guus2005

AWF VIP
Local time
Tomorrow, 00:59
Joined
Jun 26, 2007
Messages
2,645
Hi,

i have an Access 2013 application with a SQL Server 2008 backend.
Customer requested an update and with this new version several tables needed to be updated. Fields added and such. Some indexes where renamed and added

Previous version linked to the tables relativly fast in 4s.
This new version however with a few additions but no new tables linked to the backend in over 2 minutes.

Can you with this limited information give me a hint as to how this can happen?
I was thinking that perhaps indexes needed to be rebuild/reorganized and that over time linking would improve. As of yet that has not happend.

Regards,
Guus
 

Minty

AWF VIP
Local time
Today, 23:59
Joined
Jul 26, 2013
Messages
10,355
How many tables are you relinking? Have you changed the ODBC Driver ?

I relink 175 tables in 6 seconds on a very similar setup to yours.
 

CJ_London

Super Moderator
Staff member
Local time
Today, 23:59
Joined
Feb 19, 2013
Messages
16,553
indexes needed to be rebuild/reorganized
they do if there is a lot of additions/updates/deletions (because the indexes become fragmented). It should be part of a general maintenance process - similar to C&R for ACE.

Not sure if it is just the way I get involved with SQL Server but index degradation seems to affect performance much more than after equivalent exercises using ACE.

However not sure that would affect the actual linking
 

Users who are viewing this thread

Top Bottom