Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What is faster: insert from memvar or insert fields?
Message
From
24/07/2006 15:15:01
Mike Yearwood
Toronto, Ontario, Canada
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01139366
Message ID:
01139402
Views:
14
>>>Also in our case the tables have lots of extra fields never populated such as
>>>cUser_Def1,cUser_Def2, (4 fields). If I don't include them into my insert command, should it be better or it doesn't matter anyway?
>>
>>Sorry, I missed part about speed. I dunno wich one is faster.
>
>I don't want to create more tests, but once I tested it and found name to be slower.
>
>My goal is to achieve the maximum speed. Currently the process takes about an hour for 4K+ records. I want to achieve the maximum performance.

Tweaking one line here or there seldom makes for a quantum leap in performance. Only a different approach can do that. You'd need to outline the entire process.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform