Subject R: [IBO] Locate & Indexes
Author Enrico Raviglione
Hi Jason,
please can you explain some more about horizontal dataset refinement, Locate
and index behaviour ?
How can i have the best performance for make some Locate into a large

Enrico Raviglione.

-----Messaggio originale-----
Da: Jason Wharton [mailto:jwharton@...]
Inviato: lunedi 19 agosto 2002 22.54
Oggetto: Re: [IBO] Locate & Indexes

When using a query it brings records to the client. If you want special
capabilities you have to setup horizontal dataset refinement. With that few
of records it may be just as well you keep things as they are.

Jason Wharton
CPS - Mesa AZ

-- We may not have it all together --
-- But together we have it all --

----- Original Message -----
From: "Tom Deprez" <zifnabbe@...>
To: <>
Sent: Monday, August 19, 2002 1:30 PM
Subject: [IBO] Locate & Indexes

> Hi,
> I'm a little lost here. I've a TIBOQuery on a table (15795 records). The
table itself as a primary key of 'POSTCODE_ID;STREETNAME'.
> When I perform a Locate as in:
> qrSrvcsByStreets.Locate('POSTCODE_ID;STREETNAME',
> [])
> It seems to be very slow. I've to use this query each time when I want to
insert a record in another table.
> Does TIBOQuery uses the keys defined on the table automatically (since
then locate works the fastest) or do I've to define it somewhere.
> Is there a better way to do this then using locate? Stored Procedure? How
would this procedure than look like?
> Thanks in advance,
> Tom.

IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________ - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to