Article View: borland.public.cppbuilder.database.ado
Article #2868techniques for minimizing database traffic
From: Bonny Rais
Date: Thu, 13 Mar 2003 09:10
Date: Thu, 13 Mar 2003 09:10
27 lines
2089 bytes
2089 bytes
All, I've posted a question regarding the time it takes to start up an application with an active dataset of medium size (70K records). It was suggested that this happens because the cursor location is on the client which forces the loading of the complete dataset in order to facilitate sorting/filtering. However, I've changed the cursor location to be server side and now I'm getting exceptions with a dataset which is related to the above dataset and which is used to show the details in a master/detail form. I cannot set the cursor type to dynamic/static/keyset (at least this is what the ODBC driver states) and it is required to be such for bookmarks to work... what gives? I am new to C++ builder so I'm not sure what the best way to achive this is, but I'm sure many people have done this before: the scenario is a master/detail combination with ~100K master records and ~500k detail records. What's the best way to have a responsive UI without loading the complete master table into memory? Cheers, Bonny
Technical Details
Message-ID:
<3e704aed@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!nntp.theplanet.net!inewsm1.nntp.theplanet.net!zen.net.uk!fu-berlin.de!news.boerde.de!nntp.cs.uni-magdeburg.de!PeerFeed.KWeb.on.ca!news.kweb.on.ca!KWeb!newsgroups.borland.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,e3115bee4ba3f50b X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2003-03-13 01:12:31 PST From: "Bonny Rais" <bonnyr@optushome.com.au> Newsgroups: borland.public.cppbuilder.database.ado Subject: techniques for minimizing database traffic Date: Thu, 13 Mar 2003 20:10:06 +1100 Lines: 30 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 NNTP-Posting-Host: 210.49.220.198 Message-ID: <3e704aed@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1047546605 210.49.220.198 (13 Mar 2003 01:10:05 -0800) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!nntp.theplanet.net!inewsm1.nntp.theplanet.net!zen.net.uk!fu-berlin.de!news.boerde.de!nntp.cs.uni-magdeburg.de!PeerFeed.KWeb.on.ca!news.kweb.on.ca!KWeb!newsgroups.borland.com!not-for-mail