Subject Re: [IBO] copy dataset
Author Helen Borrie
At 09:11 AM 24/12/2004 +0000, you wrote:


>Hi,
>
>While doing a filters on a TIBOQuery in a wan, is too slow due to
>requering each time is filtered (even with few records). I thought to
>fetch the entire dataset without filtering to a ClientDataSet and
>then filter the ClientDataSet (this would increase performance). But
>copyiing a all datasets to a clientdatasets is a nightmare. Is there
>any manner to copy an TIBQuery to a clientdataset in a simple way?

The mind boggles!! 2-tier client/server is not designed for WANs! You
need to move your client operations to the server and build *very thin*
remote clients - ideally, web browsers.

You might be interested in visiting www.matlus.com. There are some good
doccos there re building n-tier apps with Delphi and IBO.


>Another question, when fetching a query from a table that contains
>varchars(255), is the server responsable of transmitting only the data
>used in those fields (in my case Firebird 1.5.1)?

Yes. Varchars are not padded on the wire in Fb 1.5.

Helen