Some ADO Fundamentals

Hi,

We all are using ADO quite frequently, but we are not sure if we are using it efficietnly too or not. I have given some information below, which may help you out in managing your queries.
While getting a recordset from a connection object.
Set objRS = objConn.Execute(CommandText, [RecordsAffected],[Your Options])
You can speed up your records fetching process by mentioning the options in the recordset object. Following are the options which are available:

adCmdText	If you have given the Command Text as a SQL string.
adCmdTable	It is a sign that query would return the column names of the table.
adCmdTableDirect	for a table name, whose columns are all returned.
adCmdStoredProc	for a stored procedure name.
adCmdFile	for a saved recordset.
adCmdUnknown	for an unknown command type.
adCmdUnspecified	to indicate the command type is unspecified. ADO will work out the command type itself, but this will lead to poorer performance, so you should always explicitly set the command type.

You can also add the following ExecuteOptionEnum modifiers to Options:

adAsyncExecute, for asynchronous execution.
adAsyncFetch, for asynchronous fetching.
adAsyncFetchNonBlocking, for asynchronous fetching that does not block.
adExecuteNoRecords, for a non-row returning command.

Thanks,
Vikas Bhandari