Why is it better to build SQL statements to alter data than to use curser (ADO) programming?
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
it is arguable,
a sql statement to alter data will be much more efficient as there is no extra memory/cpu cycles spent on loading/caching data you don't want.
However most of the time you are not in a Write Only mode, in which case using the cursor to navigate the dataset, obtaing data, writing data is much more flexible.
If you need raw speed and don't want the extra baggage use sql statements to modify the data
Very true in all statements.
1. sql i use for portability and mass changes of dataset for a single common result and comparison
2. cursors i use for maintenance of datasets that needs to read, check, compares and act or don't act methodology
3. i prefer SQL in almost all cases... stored procedures. and for speed... use OLE-DB instead if you can... it depends on if you control the server or not.. depends on your hosting..
thanks,
Andy
<removed by PashaMod>
"I prefer SQL because I do a lot of work on an AS400, and thus can't get ADO to work correctly."
You can use a driver available (If memory serves from IBM) which enables you to make queries against an AS400 via ADO. I have done it but it was a long time ago.
ADO is optimised however to work with SQL Server.
I still would maintain however that it is better to get the AS400 to do queries and only send required data across the network. This would mean a heavier use of Queries, Views and Stored Procedures.
Business Accounts
Answer for Membership
by: sirbountyPosted on 2004-02-25 at 09:36:33ID: 10452315
Is this a homework question?