Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Server: Getting data in.
Message
De
27/12/1996 09:18:32
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00016041
Message ID:
00016054
Vues:
41
>
>1. Is there a reasonably convenient way to "plug in" to SQL databases >2. What is the fastest way to push data into SQL server via VFP? I tried it once with a view and tablebuffering set on. Appended 10,000 records in a flash. Then I said "Tableupdate()", and near-paralysis set in on my machine. I have not yet tried using SQL pass through with pre-constructed INSERT INTO statements. Anybody had experience with this?
>
>BTW: The databases I deal with are 100-500 megs in size so there is lots of data to move around.

I think the fastest way for simple batch appending is to have temporary empty table with the same structure as existing one and:
1. Append records into remote view based on empty table.
2. Tableupdate this view to move data to SQL.
3. Call SQL stored procedure (using pass-through) to append temp table to permanent one.
Also it can be helpful to use asynchronous connection not to stop user.
Edward Pikman
Independent Consultant
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform