fast methods or functions to Search registers.

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

Article #4598

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

#4598

From: Irongizon
Date: Mon, 05 Nov 2001 16:34

14 lines
1233 bytes

Hi:

I've a Table in a SQL Server that contains 3 fields (f0, f1, f2).
f0 an f1 are set as a Unique key.
I have to search registers over f2 field. f2 field has not an index because
it slows very much other operations with the table.
I've tried using the method Find in the ADORecordset objet but it goes very
slowly. There is a method named Seek but it needs f2 to be indexed.

Any help?.

Thanks in advance.

Ra�l.

Technical Details

Message-ID: <3be6bf78_2@dnews>

Path:

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

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 10698b,4d92bcc6bc6c152e,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-11-05 08:34:22 PST
From: "Irongizon" <grangizon@lycos.es>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: fast methods or functions to Search registers.
Date: Mon, 5 Nov 2001 17:34:11 +0100
Lines: 16
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
NNTP-Posting-Host: 195.55.170.90
Message-ID: <3be6bf78_2@dnews>
X-Trace: dnews 1004978040 195.55.170.90 (5 Nov 2001 08:34:00 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews