ezfind multisite multidb indexing

Previous topic

Developer

Next topic

Author	Message
Jean-Luc Chassaing	Wednesday 14 April 2010 1:38:31 am Hello, Here is my problem I have one ez instance with multiple siteaccess each one has it's own database. My problem is : - I want ezfind ans solr to index all those sites - I want to have a single search engine for all the sites on my ez instance.
Matthieu Sévère	Wednesday 14 April 2010 1:53:23 am Hello Jean-luc, Have look at this discussion : http://share.ez.no/forums/extensions/ez-find/ez-find-fetch-in-one-specific-site-id-when-installation-is-in-multiple-site-environment It explains that searching on multiple-site that have different database is not possible with "classic" ezfind but you can use rawSolrRequest fetch to achieve this. -- eZ certified developer: http://ez.no/certification/verify/346216
Jean-Luc Chassaing	Wednesday 28 April 2010 3:05:16 am OK, I've worked it all around. Let me put it an other way. I have One Ez instance and one Solr server running. I have many siteaccess having a specific database for each of them. For each specific siteaccess, i've run the updatesearchindexsolr.php on each siteaccess having a specific database.They all share the same solr data folder. The result is that when I perform a search on each siteaccess I can retrieve results from all the accesses. I would like to be able to add a facet based on the siteaccess but I still haven't found how. I'm trying to deal with the installation. If someone could give me some clues, it would be great.

Author

Message

Jean-Luc Chassaing

Wednesday 14 April 2010 1:38:31 am

Hello,

Here is my problem I have one ez instance with multiple siteaccess each one has it's own database. My problem is :

- I want ezfind ans solr to index all those sites

- I want to have a single search engine for all the sites on my ez instance.

Matthieu Sévère

Wednesday 14 April 2010 1:53:23 am

Hello Jean-luc,

Have look at this discussion : http://share.ez.no/forums/extensions/ez-find/ez-find-fetch-in-one-specific-site-id-when-installation-is-in-multiple-site-environment

It explains that searching on multiple-site that have different database is not possible with "classic" ezfind but you can use rawSolrRequest fetch to achieve this.

--
eZ certified developer: http://ez.no/certification/verify/346216

Jean-Luc Chassaing

Wednesday 28 April 2010 3:05:16 am

OK,

I've worked it all around. Let me put it an other way.

I have One Ez instance and one Solr server running. I have many siteaccess having a specific database for each of them. For each specific siteaccess, i've run the updatesearchindexsolr.php on each siteaccess having a specific database.They all share the same solr data folder.

The result is that when I perform a search on each siteaccess I can retrieve results from all the accesses.

I would like to be able to add a facet based on the siteaccess but I still haven't found how. I'm trying to deal with the installation.

If someone could give me some clues, it would be great.

eZ debug

Timing:	Jan 18 2025 05:20:33
Script start
Timing:	Jan 18 2025 05:20:33
Module start 'layout'
Timing:	Jan 18 2025 05:20:33
Module start 'content'
Timing:	Jan 18 2025 05:20:33
Module end 'content'
Timing:	Jan 18 2025 05:20:33
Script end

Main resources:

Total runtime	0.7757 sec
Peak memory usage	4,096.0000 KB
Database Queries	58

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0051	590.4297	152.6250
Module start 'layout'	0.0051	0.0030	743.0547	39.4609
Module start 'content'	0.0081	0.7664	782.5156	544.5625
Module end 'content'	0.7745	0.0012	1,327.0781	12.1563
Script end	0.7757		1,339.2344

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0031	0.4043	16	0.0002
Check MTime	0.0013	0.1631	16	0.0001
Mysql Total
Database connection	0.0009	0.1138	1	0.0009
Mysqli_queries	0.7250	93.4671	58	0.0125
Looping result	0.0005	0.0644	56	0.0000
Template Total	0.7493	96.6	2	0.3746
Template load	0.0019	0.2390	2	0.0009
Template processing	0.7474	96.3541	2	0.3737
Template load and register function	0.0001	0.0160	1	0.0001
states
state_id_array	0.0009	0.1166	1	0.0009
state_identifier_array	0.0009	0.1185	2	0.0005
Override
Cache load	0.0015	0.1975	22	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0005	0.0653	2	0.0003
Fetch class attribute name	0.0014	0.1800	5	0.0003
XML
Image XML parsing	0.0010	0.1323	2	0.0005
class_abstraction
Instantiating content class attribute	0.0000	0.0020	6	0.0000
General
dbfile	0.0008	0.1067	22	0.0000
String conversion	0.0000	0.0013	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
3	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
3	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
4	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	content/datatype/view/ezxmltags/link.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/link.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 13 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs