There should be a tech info sheet on it. Please see the resources already
published and if you have specific questions please bring them here.

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: "Enrico Raviglione" <e.raviglione@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, August 20, 2002 4:28 AM
Subject: R: [IBO] Locate & Indexes


> 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.