linking after update very slow

[Guus2005]

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]

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]

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