Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL server slow-down on VFP...
Message
De
06/06/1999 15:24:25
James Blackburn
Qualty Design Systems, Inc.
Kuna, Idaho, États-Unis
 
 
À
22/05/1999 14:24:40
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00221775
Message ID:
00226932
Vues:
35
Hi Scott

Some conversion issues that I have had in the past.
1. Make sure that any empty memo field is set to null before inserting.
2. Drop all triggers and other contraints while doing the conversion. This is just overhead that will slow the process as the data grows.
3. Use BCP if there is a lot of data. This is much faster than going through VFP. You would have to export the data out of dbf's into a delimited format.

Hope this helps a little bit.

Jim Blackburn
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform