🚀 go-pugleaf

You should never attempt to bring all records from your remote table or query
objects into the client datasets.  Not only will it slow down your app., but
also you'll run out of memory space.  You can set the PacketRecords property of
a client dataset object to just bring in the records you need - a lot of the
time you only need a single record.  If your user is scrolling through rows,
your client app. will request additional packets as needed.

Regards,
John

Tom Barfoot wrote:

> Is there a technique for handling large tables using a multi-tier model ?
> The client side of my application takes far to long to load on startup.  It
> seems that all (12) the tables from the application server are all loaded
> locally on the client before the application is up & running.
>
> Usage:
>
> BCB 3.0
> Multi-tier application.
> Sybase Server on the back-end.
> Typical forms & controls etc. on the client-side.
>
> Thanks
>
> tom.