Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Eric den Doop
  Where is Eric den Doop?
 Houten
 Netherlands
 Eric den Doop
 To: Forizzo
  
 anycity
 
 Forizzo
 Tags
Subject: RE: table processing slowdown
Thread ID: 33914 Message ID: 33962 # Views: 1 # Ratings: 0
Version: Visual FoxPro 7 Category: Databases, Tables and SQL Server
Date: Friday, December 05, 2003 2:14:58 PM         
   


>
> 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.


Can you post some code? We can then take a look at it to see if we can improve it. If you're using the REPLACE statements on a single table, then you can better wrap it into a single command like:
REPLACE chrfield WITH "somevalue", ;
              datefield WITH DATE(), ;
              numfield WITH 123, ;
              etc ...

Resident virus scanners can slow down VFP dramatically. Make sure to exclude VFP file types (dbf, fpt etc) from the scan process.
--
Eric den Doop
www.foxite.com - The Home Of The Visual FoxPro Experts

ENTIRE THREAD

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