Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL updates and VFP table buffering
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
SQL updates and VFP table buffering
Divers
Thread ID:
00611778
Message ID:
00611778
Vues:
58
Hi,

I need to upload data to the SQL table from VFP tables. Thing is the VFP tables do not have the same structures as the SQL table and some VFP tables splits up to more than one SQL table.

I already have a translation/conversion program to get the data to the SQL database. Only problem is that the upload is slow (about 0.2 sec per record
and 10k to 50k records to upload).

Is there a faster way of doing this. I tried using a remote view of the SQL tables with buffering set to 5 (table buffering) then adding all my records and then doing a tableupdate() but it would only add 10 records or less with the rest missing. Is there a setting on the SQL server I need to set?

Any help would be greatly appreciated.

TIA,
Arriyel
Speak using soft and sweet words in case you have to eat them later.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform