Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Insert - SQL slower in VFP9 than in VFP6???
Versions des environnements
Network:
Windows 2000 Server
I've recently installed VFP9 service pack 1. We are converting an enormous amount of data to fox dbfs. I've always thought that SQL inserts were faster than append blank, and for that matter safer. (FYI, In this particular instance, we are not assigning primary keys to the tables and they are opened exclusively for this operation.)
However when running the code from within VFP 6, it is 5 times faster than in VFP9:
INSERT INTO (lcpath + lcTable) FROM memvar
For 10,000 iterations of this code, VFP9 took almost two minutes, while VFP6 took only 20 seconds.
When I replace the above line with the following, VFP9, now runs as fast or faster than VFP6:
append blank
gather memvar
What am I missing here????? I'm puzzled.
One other note, I have SET SQLBUFFERING OFF but there must be something else in play here.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement