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 18 2025 22:39:27
Script start
Timing:	Jan 18 2025 22:39:27
Module start 'layout'
Timing:	Jan 18 2025 22:39:27
Module start 'content'
Timing:	Jan 18 2025 22:39:27
Module end 'content'
Timing:	Jan 18 2025 22:39:27
Script end

Main resources:

Total runtime	0.5164 sec
Peak memory usage	4,096.0000 KB
Database Queries	54

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0041	587.7891	152.6094
Module start 'layout'	0.0041	0.0025	740.3984	39.4063
Module start 'content'	0.0066	0.5084	779.8047	484.1875
Module end 'content'	0.5150	0.0013	1,263.9922	8.1953
Script end	0.5163		1,272.1875

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0028	0.5328	16	0.0002
Check MTime	0.0012	0.2276	16	0.0001
Mysql Total
Database connection	0.0005	0.1052	1	0.0005
Mysqli_queries	0.4820	93.3489	54	0.0089
Looping result	0.0005	0.0899	52	0.0000
Template Total	0.4936	95.6	2	0.2468
Template load	0.0016	0.3041	2	0.0008
Template processing	0.4921	95.2958	2	0.2460
Template load and register function	0.0001	0.0242	1	0.0001
states
state_id_array	0.0007	0.1315	1	0.0007
state_identifier_array	0.0007	0.1325	2	0.0003
Override
Cache load	0.0012	0.2377	10	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0007	0.1282	2	0.0003
Fetch class attribute name	0.0015	0.2830	2	0.0007
XML
Image XML parsing	0.0002	0.0463	2	0.0001
class_abstraction
Instantiating content class attribute	0.0000	0.0015	2	0.0000
General
dbfile	0.0006	0.1183	10	0.0001
String conversion	0.0000	0.0014	4	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
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
2	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
2	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 6 Number of unique templates used: 4

Time used to render debug report: 0.0001 secs