Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Insert - SQL slower in VFP9 than in VFP6???
Message
De
23/02/2007 14:09:37
 
 
À
23/02/2007 13:49:44
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01198068
Message ID:
01198411
Vues:
21
This message has been marked as the solution to the initial question of the thread.
>>But check your insert statement in original post. It didn't have m.
>
>Ok I tried it again, but first I changed the variable creation lines to reflect the m. :
>
>
>m.lcInFile = "testout"
>m.lcOutfile = "testin"
>
>
>Then I tried the 10k record insert test with the following line as the insert:
>
>
>INSERT INTO (m.lcInfile) FROM memvar
>
>
>It still took 5 seconds to finish
>
>But If I comment out the following line, the 10k recs are inserted in approx. 1/2 second:
>
>
>USE testout IN 0 Exclusive ALIAS MyOUT
>
>
>I'm sure some people may view this whole thread as being a little obsessive on my part (and let me be the first to admit that I AM obsessive ;-), but again, when importing this amount of data, seconds can turn into hours.

What happens if you open the table without the alias MyOUT?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform