Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 5 of 5 total |
How i can to create an Index for 3 chars ( internal chars ) |
Fri, Aug 5 2011 11:28 AM | Permanent Link |
Mauro Botta | 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 ). |
Fri, Aug 5 2011 12:03 PM | Permanent Link |
Fernando Dias Team Elevate | 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] |
Fri, Aug 5 2011 1:07 PM | Permanent Link |
Roy Lambert NLH Associates 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] |
Mon, Aug 8 2011 5:29 AM | Permanent Link |
Mauro Botta | >> 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 |
Mon, Aug 8 2011 6:00 AM | Permanent Link |
John Hay | 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 |
This web page was last updated on Sunday, May 5, 2024 at 07:30 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |