0
559
Question Romero Terrones Esteve · Nov 10, 2017

Best way for autocomplete fast search

#Caché #SQL #iFind

Hello All,

what is the best method for search a portion of text in a non-indexed global?

I need to implement an autocomplete kind of search, in a global of >1M registers (text type, not $lb)

Maybe the best way would be use a SQL mapped class, with 'Bitmap' indexes?

 

Thanks in advance!

Discussion (4)0
Log in or sign up to continue

Comments

Vitaliy Serdtsev · Nov 10, 2017

See aside iFind.

I long ago did the tests, using Bible, at searching for of any substring.

  1. without an index 
    select Id, Para from BookPara where Para like '%огон%'
  2. with index
    select Id, Para from BookPara where id %FIND search_index(ParaStemmedI,'*огон*',1)
The number of found rows Performance (sec.) Global references
The result:
without an index 287 0.518 151845
with index 287 0.009 1006

The difference is obvious.

0
Evgeny Shvarov · Nov 10, 2017

Hi, Romero!

Look at this project which does search for Documentation with iKnow and iFind by @Konstantin.Eremin. Demo. Github.

It uses iKnow for autocomplete functionality in a search box.

0