First of all:

Inc-searching is not intended for that large result-sets....keep it smaller,
as a maximum count with 50K (100mb Lan) down to 5.000 (ISDN)

Second.....Did you ensure, the table is sorted by streetnames?? IBO should
do inc-searches only on that columns, on which the result is sorted...IBO
CAN do it also the other way, but it is not feasible for result-set relly
bigger than a hadnfull of records.....and for 500k rows a fetch of 75k rows
shows only, that you have 75k rows starting with a :-))

Inc-searching with IBO is done on the client, not on the server, so IBO has
to fetch one row after the other and compare it to the inc-criteria. It
stops, after it finds the first record matching, so here is your reason for
not using it on such large tales...

CU, Kaputnik
(Nick Josipovic)

nick@...
kap@...
-----------------------------------------------------------------------
superior Client/Server programming:
www.IBObjects.com
a nice Tool for Interbase:
www.InterbaseWorkbench.com

----- Original Message -----
From: "Bram" <bram@...>
To: <IBObjects@egroups.com>
Sent: Wednesday, January 17, 2001 11:45 AM
Subject: [IBO] increment search


> D5/IBO3.6
> I followed the increment search example in the getting started guide. I
have
> an table with 500.000 rows. I know I maybe trying to do something not C/S
> wise but I just test what the limits are. The table has an field called
> street with contains all streets in the Netherlands. I tried to do an
> incrementel search on this field. If I press B as first letter I get an
row
> fetch for about 75.000 rows. Is this what I should expect?
>
> Bram van der Voet
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>