Re: slow ADO refresh, ending in error message

From: Susan Leigh (magine_at_turtleflight.com)
Date: 02/19/04 

Date: Thu, 19 Feb 2004 01:35:56 -0500

Is around 2000 records considered exceptionally large? I wouldn't think so.

In my application it's up to the user to select the dataset, since it
lets the user enter the SQL select statement. But in the particular
database I'm using with my application myself right now, there are about
2000 records.

It seems to me that if the feature works fine with some implementations
(the ADOnis components I used with Delphi5, and the BetterADO component
with Delphi 7) and poorer with other implementations (the Delphi 7
standard ADO components) then the problem is not that "I shouldn't do
that", it's that some implementations are not as good as others.

Brian Bushay TeamB wrote:
>>Is ADO only for small databases then?
>
> You can use any size database with ADO but if you want good performance you
> should not be selecting datasets that are larger than a user can reasonably
> browse through
>
>
>
>>Brian Bushay TeamB wrote:
>>
>>>>And BTW, if Refresh is so inefficient (not that I doubt you) then why is
>>>>it the default behavior for the nav component's refresh button?
>>>
>>>That Navebar is designed to work with the generic Tdataset.
>>>TADO components just don't optimally implement refresh
>>>There is a free TADODataset descendant TbetterADODataset that you can use that
>>>has a better implementation of Refresh
>>>http://web.orbitel.bg/vassil/
>>>
>>>
>>>
>>>
>>>>Frankly I'm beginning to feel that the third-party ADO component had a
>>>>lot better implementation. Maybe I shouldn't even be bothering to port
>>>>to Delphi 7.
>>>
>>>If the component works well and you get the support you need for it keeping it
>>>may be your best decision.
>>>However you may also want to consider that if Refresh is a performance problem
>>>for you it means you are working with datasets that are larger than you should
>>>be using for optimal performance with ADO
>>>
>>>--
>>>Brian Bushay (TeamB)
>>>Bbushay@NMPLS.com
>
>
> --
> Brian Bushay (TeamB)
> Bbushay@NMPLS.com