Forums / Developer / Indexing external database content

Indexing external database content

« 
Previous topic
|
Developer
|
Next topic
 »
Author Message

Kedar Deshpande

Friday 14 August 2009 8:45:22 am

I am trying to index content from an external database and see the updatesearchindexsolr.php file has fields that allow connections to a DB but filling these in dont seem to work at all. 

array( 'db-host' => "localhost",
         'db-user' => "root",
         'db-password' => "root",
         'db-database' => "cccms",
         'db-driver' => "mysql",
         'db-type' => "mysql",
         ...

Could someone let me know if indeed this is the way to provide the parameters for external DB indexing and also how to specify which tables within the external DB to index.

thanks.

Paul Borgermans

Saturday 15 August 2009 10:43:28 am

Hi Kedar

This script is used for indexing ez publish content only

There are several routes to index external data:

- write your own script(s), using the base classes in the ezfind extension
- configuring Solr to do this for you through the search backend:
see http://wiki.apache.org/solr/DataImportHandler and make a small script using the Solr base classes from the ezfind extension to control this DataImportHandler

In both cases, you will probably need to modify the Solr schema file

To search this content, you can use the ezfind supplied rawSolrRequest fetch function in templates

In a future edition, ez find will be extended to make indexing adn searching external content easier out of the box

Regards
Paul

eZ Publish, eZ Find, Solr expert consulting and training
http://twitter.com/paulborgermans

eZ debug

Timing: Jan 19 2025 13:43:59
Script start
Timing: Jan 19 2025 13:43:59
Module start 'content'
Timing: Jan 19 2025 13:43:59
Module end 'content'
Timing: Jan 19 2025 13:43:59
Script end

Main resources:

Total runtime0.1499 sec
Peak memory usage2,048.0000 KB
Database Queries141

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0056 588.9766180.8281
Module start 'content' 0.00560.0066 769.804794.0078
Module end 'content' 0.01220.1377 863.8125522.5469
Script end 0.1499  1,386.3594 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00362.4146200.0002
Check MTime0.00151.0092200.0001
Mysql Total
Database connection0.00080.519510.0008
Mysqli_queries0.111174.12571410.0008
Looping result0.00110.70511390.0000
Template Total0.137391.610.1373
Template load0.00090.574210.0009
Template processing0.136490.996210.1364
Override
Cache load0.00060.405510.0006
Sytem overhead
Fetch class attribute can translate value0.00040.294010.0004
XML
Image XML parsing0.00020.118610.0002
General
dbfile0.00463.0794200.0002
String conversion0.00000.004130.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs