Hi

i have a very big database

only 10 string field, but Milions of records.

i must search in FAST mode for words included in Field String n.1


The Filter must to be optimized by a Index.

example :

Field 1 value :  QWERTY UIOPASD FGHJKL ZXCV BNM

i need search for : WER  
or
i need search for : WER  +  UIO + GHJ


can make this with Dbisam 4 ? EDB 1.0  EDB 2.0 ?

Enrico,

<< can make this with Dbisam 4 ? EDB 1.0  EDB 2.0 ? >>

EDB (1.x or higher) can do this with a LIKE operation (LIKE '%WER%')
provided that there's an index on the VARCHAR or CHAR column.

However, it does have to search the entire index, so although it will be
faster than a brute-force table search of the actual rows, it won't be as
fast as a trailing wildcard search (LIKE 'WER%').

--
Tim Young
Elevate Software
www.elevatesoft.com

Enrico


You can't do it in DBISAM but you should be able to in ElevateDB. You'll need to set up a full text index on the field then do something like

SELECT * FROM table WHERE Field1 CONTAINS '*WER* *UIO* *GHJ*'

if you want it case insensitive add COLLATE ANSI_CI to the statement.

I can't remember if the wildcard either side of the search word was in 1.08 or will be in 2.0

Roy Lambert

Roy,

<< I can't remember if the wildcard either side of the search word was in
1.08 or will be in 2.0 >>

It's in 1.08, but I forgot to announce/document it so I announced it for 2.0
instead.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


Had you given any thought to swapping % for * so that it looks compatible with LIKE?

Roy Lambert

Roy,

<< Had you given any thought to swapping % for * so that it looks compatible
with LIKE? >>

Actually, yes.  You're referring to CONTAINS, correct ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


Yup

Roy Lambert