wow, it looks like DIH already works with relational databases... thanks again!
2009/9/1 Pablo Ferrari <pabs.ferr...@gmail.com> > Thanks Aakash! > > I've looked at it and it looks very interesting, the problem is that my > database is a relational model, therefore I don't have a table with all the > information, but many tables related to each other by their ids (primary > keys and foreign keys). > > I've been thinking about using DataImportHandler in any of this two ways: > - Write a script that creates a table with all the information I need for > searching (it is not very efficient because of duplicate data) > - Configure DataImportHandler with some JOIN SQL statement > > I'll let you know how I did, thanks again! > > Pablo > > 2009/9/1 Aakash Dharmadhikari <aaka...@gmail.com> > > hi Pablo, >> >> DataImportHandler might be the best option for you. check this link >> http://wiki.apache.org/solr/DataImportHandler >> >> regards, >> aakash >> >> On Tue, Sep 1, 2009 at 9:18 PM, Pablo Ferrari <pabs.ferr...@gmail.com >> >wrote: >> >> > Hello all, >> > >> > I'm new to the list and new to Solr. My name is Pablo, I'm from Spain >> and >> > I'm developing a web site using Solr. >> > >> > I have Solr with the examples working correctly and now I would like to >> > load >> > the data from a MySQL database using php. >> > Is the best way to do this to write a php script that get the info from >> the >> > MySQL and then generates an XML document to load into Solr? Is there a >> > maximum size for this XML document? My MySQL database is quite big... >> > >> > Any help, book or internet tutorial you know will be really appreciated. >> > >> > Thank you! >> > >> > Pablo >> > >> > >