I’ve run across a little bit of an issue with an application for a client that we’ve been working on the last few days. We’ve re-written an Access database application. Our normal protocol is to always separate the data from the application.
The problem is that when we do this the application runs it’s processing routines and queries run at fractions of the speed. When the data and application are joined, the queries run and process 300+ records in just over a minute. When separated that time jumps to about 30-45 minutes.
Has anyone seen this and determined a solution for making it not happen? I read of some issues that may cause it to be happening, but we have implemented any of the specific items mentioned in that article.