Jump to content

Solution Running Slow


kelbantaemi
 Share

This topic is 5649 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I'm not sure if this is the right forum, if not please direct me to were I should post this. My problem is this, I have a FM7 File that needs to periodically update via ODBC, some of the tables require existing records be deleted and imported again. Solution has worded well for months. But now the record updates are VARY SLOW (aprox time is 10-15mins) It’s not just the ODBC it is the record delete step that is slow. It will also hang filemaker from time to time. Originally time was aprox 1 min or less. File size is consistently about 1 meg, record import is about 10,000 records consisting of 4 to 9 fields depending on the table of which there is a total of 4. The Machine is windows XP SP2. I can run the same solution from my machine which is a carbon copy of the other machine, and solution runs as normal.

Where might I begin to look for problem.

Link to comment
Share on other sites

Hi,

PC's can accumulate temp files in the temp directory which can slow them down. May not be your problem, however these files are often left as a result of a system lockup. 1. close all programs except the OS 2.Go to mycomputer/cdrive/documents and settings/youruserid/local settings/temp and delete all the temp files that the system will allow you to delete. Some will be in use by the os. There should be only 3 or 4 files here used by the os. This will not hurt your computer it is just a temporary place Windows uses to store temp information and will be rebuilt the next time it is needed. 3. If this does not work you might need to defragment your drive volume. This can become a problem if software has been installed and removed from your drive. To defragment :) start/programs/accessories/defragment.

If these bring no help to your problem, then turn your attention to your odbc driver and DSN.

Hope this helps,

Tim

Link to comment
Share on other sites

This topic is 5649 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.