Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Inserting large amounts of data
Message
From
07/07/2000 16:20:54
Charlie Schreiner
Myers and Stauffer Consulting
Topeka, Kansas, United States
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00389512
Message ID:
00389663
Views:
11
Hi Pat,
Remember this.
APPEND BLANK, REPLACE, REPLACE - Very slow, CDX may need to be updated 3 times.

INSERT INTO - Better, CDX only is updated once per record. Still a lot of network traffic in that a CDX lock and a DBF Header lock are needed for each record inserted.

APPEND FROM - Best since DBF Header is locked only once for all records. CDX update may occur only once as well. I don't know this is true, but it would may sense since no other user would even know the new records exist until the append has completed and the DBF header is unlocked.

If you can use the Table exclusively, so much the better.

>I have a form that is reading data from several text files and inserting it into tables. It has been running for 26 hours so far. I have a wait window that is showing me a counter. I have noticed that it is getting slower and slower the longer it runs.
>
>Is there anything I can do to prevent it from slowing down?
>
>Thanks
>
>Pat Murphy
Charlie
Previous
Reply
Map
View

Click here to load this message in the networking platform