Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Insert - SQL slower in VFP9 than in VFP6???
Message
From
23/02/2007 14:09:37
 
 
To
23/02/2007 13:49:44
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01198068
Message ID:
01198411
Views:
20
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?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform