Hi,
We are trying to improve performance with COM+ components we are currently using. I've read that you should always close ADODB recordsets prior to setting them to nothing.
We currently use ADOMD.Cellset's to connect to SQL Server Analysis Services. What we are trying to determine is if an ADOMD.Cellset should also be closed prior to setting to Nothing? Are there any pros or cons to doing this?
We are trying to improve performance with COM+ components we are currently using. I've read that you should always close ADODB recordsets prior to setting them to nothing.
We currently use ADOMD.Cellset's to connect to SQL Server Analysis Services. What we are trying to determine is if an ADOMD.Cellset should also be closed prior to setting to Nothing? Are there any pros or cons to doing this?