Tuesday, August 3, 2010

Comparison of Insert and Rs.Addnew


Add a new record is way through the RecordSet object Addnew achieved, or by executing SQL statements in the insert statement can also add new records, why not choose the latter case? What is the difference between the two then?

In essence, ADO's Addnew method simply "Insert into" statement to package up, so direct use of SQL statement will greatly accelerate the speed of access to data, because he reduced the ADO's "translation" of time, especially when on When large amounts of data to operate more obvious. However, the shortcomings of the direct use of SQL statements: can not transfer the contents of the field too long, in the IMAGE field to the database by adding data, long text data, you need to use Addnew the. In addition, when the field is relatively long time to be a very long SQL statement, which led to easy troubleshooting, experienced programmers recommend priority.

In comparison, RecordSet object Addnew method first need to create a RecordSet object can be updated and maintained to Update the end, it is more consumption of system resources. But it has the advantage of better flexibility, code easy to read, easy debugging, recommend new users.







Recommended links:



Infomation Games Board



SAN TERMINOLOGY Reference Table



Articles about Help Tools



Chi-line LUBRICATION experts



Ministry of Information Industry said the first year RFID frequency schedule announced



mp4 to avi



Screen Savers Specialist



CONVERT flv to wmv



"The Sims 3" fun things continue to occur



The latest satellite positioning chips used indoors less than one second positioning



Principal to ensure each experience a 20 006 practice site



Music TV infringement trial basis have a SPECIAL levy to the views of the community



mov Video



Photoshop font effects - Ice text



Art - Screen Savers Report



Matroska video file