Forums / General / Substring search

Substring search

Next topic

Author	Message
Gabriel Ambuehl	Tuesday 18 January 2005 11:53:32 am Is there any way I can enable substring searches? This is a major deal in German which uses loads of concatenated nouns but also in other languages and with lazy users. This shouldn't be too hard (might be as simple as changing WHERE field='keyword' clauses to WHERE field like '%keyword%' to do... Also, how about soundex searches / different spellings of the same word, but that's obviously a lot harder than substring searches ;-) Visit http://triligon.org
Jo Havik	Wednesday 19 January 2005 5:15:36 am There is no easy way to search for substrings (at least as I know :). The '%keyword%' approach does not work since the structure of the search engine cannot cope with the possibility of a SQL query returning more than one word (an exact match). Cannot remember the details, havent looked at this for some time. We have, however, created a patched version of the search engine (for eZ publish v. 3.4) that indexes substrings of each word. This works, but your database will grow quite large.. Let me know if you want me to send this patch to you. Jo H -- Jo Havik / jo.havik at bodonihus.no

Author

Message

Tuesday 18 January 2005 11:53:32 am

Is there any way I can enable substring searches? This is a major deal in German which uses loads of concatenated nouns but also in other languages and with lazy users. This shouldn't be too hard (might be as simple as changing WHERE field='keyword' clauses to WHERE field like '%keyword%' to do...

Also, how about soundex searches / different spellings of the same word, but that's obviously a lot harder than substring searches ;-)

Visit http://triligon.org

Jo Havik

Wednesday 19 January 2005 5:15:36 am

There is no easy way to search for substrings (at least as I know :). The '%keyword%' approach does not work since the structure of the search engine cannot cope with the possibility of a SQL query returning more than one word (an exact match). Cannot remember the details, havent looked at this for some time.

We have, however, created a patched version of the search engine (for eZ publish v. 3.4) that indexes substrings of each word. This works, but your database will grow quite large..

Let me know if you want me to send this patch to you.

Jo H

--
Jo Havik / jo.havik at bodonihus.no

eZ debug

Timing:

Jan 19 2025 00:33:34

Script start

Timing:

Jan 19 2025 00:33:34

Module start 'content'

Timing:

Jan 19 2025 00:33:34

Module end 'content'

Timing:

Jan 19 2025 00:33:34

Script end

Main resources:

Total runtime

0.0213 sec

Peak memory usage

2,048.0000 KB

Database Queries

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0099	587.5781	180.8516
Module start 'content'	0.0099	0.0057	768.4297	93.5938
Module end 'content'	0.0156	0.0056	862.0234	70.7031
Script end	0.0212		932.7266

Checkpoint

Start (sec)

Duration (sec)

Memory at start (KB)

Memory used (KB)

Script start

0.0000

0.0099

587.5781

180.8516

Module start 'content'

0.0099

0.0057

768.4297

93.5938

Module end 'content'

0.0156

0.0056

862.0234

70.7031

Script end

0.0212

932.7266

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0024	11.2741	12	0.0002
Check MTime	0.0012	5.6057	12	0.0001
Mysql Total
Database connection	0.0019	9.0193	1	0.0019
Mysqli_queries	0.0043	20.3395	4	0.0011
Looping result	0.0000	0.1795	2	0.0000
Template Total	0.0052	24.4	1	0.0052
Template load	0.0008	3.9331	1	0.0008
Template processing	0.0043	20.4012	1	0.0043
Override
Cache load	0.0006	2.6116	1	0.0006
General
dbfile	0.0005	2.2223	10	0.0000
String conversion	0.0000	0.0505	3	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Accumulator

Duration (sec)

Duration (%)

Count

Average (sec)

Ini load

Load cache

0.0024

11.2741

0.0002

Check MTime

0.0012

5.6057

0.0001

Mysql Total

Database connection

0.0019

9.0193

0.0019

Mysqli_queries

0.0043

20.3395

0.0011

Looping result

0.0000

0.1795

0.0000

Template Total

0.0052

24.4

0.0052

Template load

0.0008

3.9331

0.0008

Template processing

0.0043

20.4012

0.0043

Override

Cache load

0.0006

2.6116

0.0006

General

dbfile

0.0005

2.2223

0.0000

String conversion

0.0000

0.0505

0.0000

Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	pagelayout.tpl	<No override>	extension/sevenx/design/simple/templates/pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Usage

Requested template

Template

Template loaded

Edit

Override

pagelayout.tpl

<No override>

extension/sevenx/design/simple/templates/pagelayout.tpl

Number of times templates used: 1
Number of unique templates used: 1

Time used to render debug report: 0.0001 secs