Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Enterprise
Expertise: Advanced
Mar 21, 2000

Take Advantage of ADO Optimizations

A common user scenario in a development environment is where the code typically opens a connection, executes a row or non-row returning command, processes results, and closes the connection. For such scenarios, it is better to use Connection::Execute than Recordset::Open or Command::Execute.

ADO 2.0 utilizes some optimizations for one-time command executions when done through Connection::Execute. Actually, when Connection::Execute is used, ADO doesn't preserve any command state information and therefore leads to an improved performance.

Jai Bardhan
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap