Severe Performance Hit

[dynamictiger]

When I split my backend tables off from my application and use the link manager to link them my application is taking a severe performance hit.

What do I do from here, should I look at an SQL backend or quite what?

 

[rockman]

My experience:

Started with a front end (application)/back end (database) configuration. Got bigtime delays. And very inconsistantly so (sometimes response was quick, other times very SLOW).

Three days ago I combined front end and back end (based on suggestions from this forum) and speed is much better and consistant.

Just one guys experience,

HTH

Jeff

 

[dynamictiger]

What version Access are you running? I have not had this problem before and suspect it may be a 2002 problem.

 

[rockman]

using 2000 on an XP home peer-to-peer network

 

[dynamictiger]

I'm running XP Pro (peer to peer). I wonder if it is an XP thing???

 

[rockman]

Dont know, but I was glad to get rid of the problem by combining. It's a bit tougher to work on the program without a front end to tweek but the performance issue is a no-brainer.

 

[pono1]

As Jeff said, there are discussions on this forum covering this interesting Access 2000/2002 slowdown feature.

Yet most roads lead back to this web page. Of all the suggestions offered there, I'd start by turning off Track Name AutoCorrect.

Regards,
Tim

 

[dynamictiger]

This has helped a bit. I hjad to do the following before I started to only get double the load time.

Turn all tables subdatasheets to [None]
Turn off Autoname Correct
Decompile the frontend

I am using and need to use pessimestic recordlocks.