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
dataset?

Thanks,
Enrico Raviglione.


-----Messaggio originale-----
Da: Jason Wharton [mailto:jwharton@...]
Inviato: lunedi 19 agosto 2002 22.54
A: IBObjects@yahoogroups.com
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
http://www.ibobjects.com

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

----- Original Message -----
From: "Tom Deprez" <zifnabbe@...>
To: <IBObjects@yahoogroups.com>
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',
>
VarArrayOf([tbExtInvitations.FieldByName('POSTCODE_ID').AsInteger,
>
tbExtInvitations.FieldByName('PERSON_STREETNAME').AsString]),
> [])
>
> 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.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/