BufDataSet speed

[HappyLarry]

In order to perform calculations on the fields of a Bufdataset I need to access each record in the dataset. I 'scroll' through the dataset with

Code: Pascal  [Select][+][-]

1.       Self.First;
2.       While not Self.EOF do
3.       begin
4.         Self.next;
5.       end;

It seems quite slow (e.g. 2 secs for 10000 records or 14 secs for 30000 records) - perhaps this is about right?

Am I doing this in the best way or is there a better way?

[marcov]

Is the set wired to some grid? Best is to do such things on datasets that are not bound to GUI controls.

[HappyLarry]

Thanks marcov - it makes a huge difference - it now loads in millisecs which is good.

However, once I have 'wired' the dataset to datasource1 with
   Datasource1.dataset := T;
in order to show iit, I can't see how to 'unwire' it in order to scroll and then wire it again to show the results.

Neither
    Datasource1.dataset.cancel
nor
    Datasource1.enabled:=false;
nor
   Datasourse1.destroy
'unwires it'.

This may be obvious, but how can I temporarily unwire Datasource1 from my dataset?

[ttomas]

Code: Pascal  [Select][+][-]

1.    Self.DisableControls;
2.    try
3.       Self.First;
4.       While not Self.EOF do
5.       begin
6.         Self.next;
7.       end;
8.    finally
9.       Self.EnableControls;
10.    end;
11.