Large Tables ??

Thread View: borland.public.cppbuilder.database.multi-tier

4 messages

[T] Back to Threads [V] Tree View [G] Group Articles

4 total messages Started by Tom Barfoot Wed, 03 Nov 1999 00:00

#1522

Author: Tom Barfoot
Date: Wed, 03 Nov 1999 00:00

15 lines
973 bytes

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.

Re: Large Tables ??

#1523

Author: Serif Selcuk
Date: Wed, 03 Nov 1999 00:00

3 lines
662 bytes

How Large are your tables? I have tables with ~50000 records and the
application loads pretty fast.

Re: Large Tables ??

#1524

Author: Mark Cashman (TeamB BCB)
Date: Wed, 03 Nov 1999 00:00

14 lines
1084 bytes

Hi, Tom!

I believe using TClientDataSet on the client side data module, and
TQuery in the middle-tier data module should help if you haven't done
that already.

------
Mark Cashman (TeamB - C++ Builder), creator of The Temporal Doorway at
http://www.temporaldoorway.com
- Original digital art, writing, music and more -
C++ Builder / JBuilder Tips and The C++ Builder Programmer's Webring
(Join us!)
http://www.temporaldoorway.com/programming/index.htm
------

Re: Large Tables ??

#1404

Author: John Graham
Date: Sun, 14 Nov 1999 00:00

27 lines
1508 bytes

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.

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads