Re: Benefits of using TADODatasets over TADOQuery when running local MSDE


>I am running very complex reports against a large database (greater then 1
>gig). I am curious if there is any benefit in using a Dataset over a query
>when an external server is not involved?
They will be the same speed wise.
Setting DisableControls to true before opening the dataset will speed up the
response some.
If you can do any preprocessing or the records in a stored procedure so you can
return a smaller recordset to the report that would be the best way to speed it
up.
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.