Hi Brian, Not exactly solution to your problem. But it may help, you can run Solr directly on top of your database, if your schema is simple manipulation of the database fields. This way you only need to update the database and solr index will be automatically updated with the latest data. I am using this in production and it's working pretty neatly.
Here are few helpful links: http://wiki.apache.org/solr/DataImportHandler http://www.params.me/2011/03/configure-apache-solr-14-with-mysql.html -param On 1/4/12 2:50 PM, "Brian Lamb" <brian.l...@journalexperts.com> wrote: >Hi all, > >I've been exploring http://www.php.net/manual/en/book.solr.php as a way to >maintain my index. I already have a PHP script that I use to update a >database so I was hoping to be able to update the database at the same >time >I am updating the index. > >However, I've been getting the following error when trying to run >$solr_client->commit(); > >Unsuccessful update request. Response Code 0. (null) > >I've tried looking to see why I'm getting the error but I cannot find a >reasonable explanation. My guess is that it is because my index is rather >large (22 million records) and thus it is timing out or something like >that >but I cannot confirm that that is the case nor do I know how to fix it >even >if it were. > >Any help here would be greatly appreciated. > >Thanks, > >Brian Lamb
