Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Forizzo
Subject: table processing slowdown
Thread ID: 33914 Message ID: 33914 # Views: 2 # Ratings: 0
Version: Visual FoxPro 7 Category: Databases, Tables and SQL Server
Date: Friday, December 05, 2003 1:50:59 AM         


I am having a slowdown while processing a table.

I am using a fairly simple program that takes a wide table (about 200 fields and 15,000 records) and first does a while loop clearing a small number of temporary fields in all records. Then the program does a second while loop that goes through a second sorted table (about 50 fields and 60,000 records), compiles a couple records with matching keys into some variables and then stuffs the data from the variables into the temporary fields in the original table using a seek. The program then generates a report and finishes.

I can run the program twice with slight performance issues (expected). The third time the program runs it experiences a dramatic slowdown in the first while loop after clearing the temporary fields of the first couple hundred records. Then the program runs extremely slow until it ends. These tables are free tables (not using a db). The while loop where the slowdown occurs is fairly tight (only 18 lines with about 11 'replace fieldname with ' statements to clear a couple char, date, and num fields) and the second table isn't even open yet. This would be the last place I would expect a slowdown.

The indexes on both tables are 6 chars + 25 chars. The first table has a couple dozen other indexes also. I am running across a fairly fast network and can duplicate the problem in many other similar environments. OS is xp pro.

Any ideas?




table processing slowdown Posted by Derf Forizzo @ 12/5/2003 1:50:59 AM
RE: table processing slowdown Posted by Sivaramakrishnan Parameswaran @ 12/5/2003 5:20:07 AM
RE: table processing slowdown Posted by Eric den Doop @ 12/5/2003 2:14:58 PM
RE: table processing slowdown Posted by Derf Forizzo @ 12/7/2003 10:54:34 PM