Hi All,
One of a queries properities is 'recordset type' and it defaults to
'dynaset'. If I have a query which is just a select query is there any
advantage to setting that property to snapshot?
will I get an increase in performance?
thanks
bobh.
On Nov 29, 1:10 pm, bobh
> Hi All,
>
> One of a queries properities is 'recordset type' and it defaults to
> 'dynaset'. If I have a query which is just a select query is there any
> advantage to setting that property to snapshot?
> will I get an increase in performance?
> thanks
> bobh.
oooops, I should add a little more to this
any performance increase using an access back-end?
any advantage changing it when using a SQLServer back-end(query can
Not be made into a 'pass-thru' query)