How to open an ADO dataset without getting all the records

Article View: borland.public.cppbuilder.database.ado

Article #4583

Back to borland.public.cppbuilder.database.ado Previous Next

#4583

From: Alfredo Santizo
Date: Thu, 06 Dec 2001 19:21

20 lines
1606 bytes

Hi:

All the DataSet concepts arount Delphi/C++B work nicely if you are working
with small tables...but what happens when you want to work with tables that
have 500K records and up....I would like to be able to open the dataset
without executing the query in order to allow the user to immediately insert
new records....and only obtaining records based on user-defined criteria....

Is there a way to overcome this limitation?

What about MIDAS? Imagine that you have a banking application running on
MIDAS with 300,000 accounts...How can 100 users open simultaneously a
Provider dataset that executes this query?

I am relatively new to Borland's architecture so I will appreciate if
someone can share their experiences...

Thanks

Alfredo

Technical Details

Message-ID: <3c106c25$1_1@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!hub.org!hub.org!PeerFeed.KWeb.on.ca!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,3e9852488c33c3ac,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-12-07 02:29:22 PST
From: "Alfredo Santizo" <alfredo.santizo@infocorpsoftware.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: How to open an ADO dataset without getting all the records
Date: Thu, 6 Dec 2001 13:21:53 -0600
Lines: 22
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
NNTP-Posting-Host: 216.230.139.131
Message-ID: <3c106c25$1_1@dnews>
X-Trace: dnews 1007709221 216.230.139.131 (6 Dec 2001 23:13:42 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!hub.org!hub.org!PeerFeed.KWeb.on.ca!dnews