Article View: borland.public.cppbuilder.database.ado
Article #2843slow loading of application because of open dataset
From: Bonny Rais
Date: Mon, 10 Mar 2003 06:27
Date: Mon, 10 Mar 2003 06:27
17 lines
1428 bytes
1428 bytes
All, I find that an application I'm writing is taking a very long time to show up because a dataset which is connected to the database is taking long to complete. Is there anyt way to eliminate or amortise this time? The dataset is an ADO table (I've tried queries as well) connected to a medium size table with about 70K records. It seems as if the application is loading the complete table into memory (why?). Any help would be appreciated. Cheers, Bonny
Technical Details
Message-ID:
<3e6c305a$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!newsfeed.news2me.com!fu-berlin.de!news.boerde.de!nntp.cs.uni-magdeburg.de!PeerFeed.KWeb.on.ca!news.kweb.on.ca!newsgroups.borland.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,dc7465b913df9596,start X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2003-03-09 22:28:58 PST From: "Bonny Rais" <bonnyr@optushome.com.au> Newsgroups: borland.public.cppbuilder.database.ado Subject: slow loading of application because of open dataset Date: Mon, 10 Mar 2003 17:27:40 +1100 Lines: 19 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: <3e6c305a$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1047277658 210.49.220.198 (9 Mar 2003 22:27:38 -0800) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!newsfeed.news2me.com!fu-berlin.de!news.boerde.de!nntp.cs.uni-magdeburg.de!PeerFeed.KWeb.on.ca!news.kweb.on.ca!newsgroups.borland.com!not-for-mail