Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Fastest way in VFP
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00610189
Message ID:
00610499
Views:
19
Right. If you're using row buffering (the default for a view) and have your connection set to automatic transactions, an update and commit will occur for every row. If you set your connection to manual transactions and did a commit at the end of the append that would speed things up.

If your only goal is to transfer data from one database to the other, then the code Andy Kramek suggests would probably be faster yet.

>That works OK, but I think it's actually doing an insert and commit for every record because it takes quite a while(one record every 1-4 seconds, >300,000 records). I'm looking into transactions with only one commit, but I'm not sure how much faster it would work. I'm trying to get something faster than the native(Ingres) "copy to flat file" and the native(Oracle) "copy into table from flat file". So far, appending is the simplest choice, but the slowest. Thanx though
Previous
Reply
Map
View

Click here to load this message in the networking platform