ADO related question
Posted on 2004-10-04
If I use command object and then execute the query , recordset returned by execute method is fast compare to calling open method of recordset with following parameters Open("mast_sntlc_essence",vNull, adOpenStatic, adLockOptimistic, adCmdTable);
Could you tell me why one recordset which is returned by execute method of command object is fast compare to recordset with open method.
Could you provide me any link or material which can tell me what are various parameters to use in diffenent condition ( add,modify,display,delete ) to a large database so that operation will be faster.