Hi

I have a database EDB 2.05 with 3 Milions of records.
only one field description ( 50 chars )

i should want create an index for all chars from 3 chars and above..

example :

search : ALA

db :

xxALAxx
ALAxxxx
ALA xxxx
xxALA XXXX
xx ALA xxx
..............
ALxAxxxx   ( this not !! )
.............

i need found all 5 records above with a fast index ( max 1 second for
query ).

Mauro

I'm not sure if I understood what you want...
Are the 3 characters always in the same position in the column?
If they are you can create a COMPUTED or GENERATED column, that is a substring of Description and index it.
If those 3 characters are not at a fixed position, perhaps a "Text Index", but it is going to index whole words, not arbitrary substrings, and I'm not sure if it's appropriate for what you need.

--
Fernando Dias
[Team Elevate]

Mauro


I'll back up Fernando's suggestion. Try a full text index. These days you can put a wildcard (*) at either end (I think I remember reading).

Roy Lambert [Team Elevate]

>> I'll back up Fernando's suggestion. Try a full text index. These days you
>> can put a wildcard (*) at either end (I think I remember reading).


in this mode i must to elaborate my db every time for to change index world
( update world list for full text index  )
it is not good for me.


I need make a form for make generic query at my DB , searching any word in
my db ( in fast mode )
like google search

i need to execute much much query "select myfielddescription like &xx&" with
db optimized
i should at db : Indexed all near chart for 3-4 charatters.

p.s.
3 Milions of records. ( read only db )
Delphi XE + EDB 2.05x

Mauro
> I have a database EDB 2.05 with 3 Milions of records.
> only one field description ( 50 chars )
>
> i should want create an index for all chars from 3 chars and above..
>
> example :
>
> search : ALA
>
> db :
>
> xxALAxx
> ALAxxxx
> ALA xxxx
> xxALA XXXX
> xx ALA xxx
> .............
> ALxAxxxx   ( this not !! )

Did you look at the thread "lightningfast partial search with custom word generator" in the extensions group?  This
looks like it might solve your problem.

John