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:19:37
Rick B. Mangum
Lakeside Software
Utah, United States
 
 
To
23/02/2007 14:09:37
Rick Bednarik
New Jersey, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Insert - SQL slower in VFP9 than in VFP6???
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01198068
Message ID:
01198418
Views:
14
>What happens if you open the table without the alias MyOUT?

Wow. That was it...!

If I don't use the Alias, the code executes just as fast as if I comment out the line to open the table. Is this documented somewhere? IOW, should I feel stupid on this one?

Rick, Thanks for the suggestion. Anyone know why opening a table with an alias would cause the performance drop on the insert?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform