Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only