Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>I recently switched from using views to using sql pass through. I have an operation that inserts about 6800 records. With the switch from views to sql pass thru the time has increased significantly. The sqlpassthru command that inserts the records inserts each individually and runs for 100 seconds. Is there something I missed when doing this or should I have stayed with views?
>
>Your views may have been doing updates using the primary key field only, while your SPT may be doing the equivalent of key fields and modified fields.
>
>You have more control with SPT. How are you doing the updates?
I do recall having my views set to pk only. I connect to oracle via sqlstringconnect([dsn=GBG DDE LM;uid=dsd;pwd=dbuser;],.T.) and the only other change I make to the connection is to do manual transactions for all my updates and do an sqlcommit when done. I will have a look at how the updates are being done.
Previous
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