Adexecutenorecords?
Adexecutenorecords?
Adexecutenorecords?
Adexecutenorecords?
Adexecutenorecords?
Adexecutenorecords? Adexecutenorecords? Adexecutenorecords? Adexecutenorecords? Adexecutenorecords? Adexecutenorecords? Adexecutenorecords? Adexecutenorecords?
Adexecutenorecords? Adexecutenorecords?
Adexecutenorecords?
Go Back  Xtreme Visual Basic Talk > > > Adexecutenorecords?


Reply
 
Thread Tools Display Modes
  #1  
Old 07-18-2016, 03:42 AM
sal21 sal21 is offline
Junior Contributor
 
Join Date: Mar 2004
Posts: 260
Default Adexecutenorecords?


Googling ...

i have see adexecutenorecods boost sql with ado.

but wath is the correct code top have a a good performance?:

1) .Execute , , adCmdText And adExecuteNoRecords
2) .Execute , , adCmdText or adExecuteNoRecords
3) .Execute , , adExecuteNoRecords
4) .Execute , , adCmdText + adExecuteNoRecords
5) .Execute , , 129

.. and i need to use begintrans and commitrans in associtiation, for boosting when i use adexecutenorecords?

note:_
i use Access database and ADO and vb6
Reply With Quote
  #2  
Old 07-21-2016, 10:57 PM
Dennis DVR's Avatar
Dennis DVRAdexecutenorecords? Dennis DVR is offline
Back in the Game

Forum Leader
* Expert *
 
Join Date: Nov 2003
Location: Manila Philippines
Posts: 3,576
Default

Quote:
Originally Posted by sal21 View Post
Googling ...

i have see adexecutenorecods boost sql with ado.

but wath is the correct code top have a a good performance?:

1) .Execute , , adCmdText And adExecuteNoRecords
2) .Execute , , adCmdText or adExecuteNoRecords
3) .Execute , , adExecuteNoRecords
4) .Execute , , adCmdText + adExecuteNoRecords
5) .Execute , , 129

.. and i need to use begintrans and commitrans in associtiation, for boosting when i use adexecutenorecords?

note:_
i use Access database and ADO and vb6
You should use adExecuteNoRecords if you are executing an action query like INSERT, UPDATE. This will improve the performance by minimizing the internal process. You have to understand that Action queries returns a closed recordset and by specifying the adExecuteNoRecords you are instructing ADO to not create a set of data records.

I'm not sure about the other options, but adCmdText + adExecuteNoRecords seems to be the normal way of doing it. adCmdText means the query is a SELECT statement.
__________________
Avatar by Lebb

[Posting Guidelines] [Standards & Practices Tutorial] [Participate here effectively]
Our knowledge can only be finite, while our ignorance must necessarily be infinite. Karl Popper
Reply With Quote
Reply

Tags
.execute, adcmdtext, adexecutenorecords, associtiation, boosting


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
Adexecutenorecords?
Adexecutenorecords?
Adexecutenorecords? Adexecutenorecords?
Adexecutenorecords?
Adexecutenorecords?
Adexecutenorecords? Adexecutenorecords? Adexecutenorecords? Adexecutenorecords? Adexecutenorecords? Adexecutenorecords? Adexecutenorecords?
Adexecutenorecords?
Adexecutenorecords?
 
Adexecutenorecords?
Adexecutenorecords?
 
-->