Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with Upsizing Wizard
Message
De
01/03/2002 17:24:05
Joel Leach
Memorial Business Systems, Inc.
Tennessie, États-Unis
 
 
À
01/03/2002 09:15:39
Joel Leach
Memorial Business Systems, Inc.
Tennessie, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00626735
Message ID:
00627259
Vues:
13
For anyone else following this thread, if you run into the same issues I have, I recommend turning off the new Bulk Insert functionality, at least until MS fixes it. You can do so by commenting the lines indicated below:
		* If survived all conditions above, we can go fast
			IF EMPTY(lcExportType)
*JAL*					IF this.ServerType#"Oracle" AND THIS.ServerVer>=7
*JAL*						lcExportType = "BULKINSERT"  && specific to SQL vers >= 7
*JAL*					ELSE
					lcExportType = "FASTEXPORT"
*JAL*					ENDIF
			ENDIF
Bulk Inserts can provide performance gains, but the ConvertVFPLogicalToSQLServerBit() method is slow, so it negates any gains if you have logical fields.
Joel Leach
Microsoft Certified Professional
Blog: http://www.joelleach.net
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform