Best practice for storing relational data in Solr

2008-01-04 Thread steve.lillywhite
Hi all, This is a (possibly very naive) newbie question regarding Solr best practice... I run a website that displays/stores data on job applicants, together with information on where they came from (e.g. which recruiter), which office they are applying to, etc. This data is stored in a m

Re: Best practice for storing relational data in Solr

2008-01-08 Thread Ryan Grange
I've found that Solr running on modest hardware (a 2.4 GHz PC running Windows XP Pro for testing changes) is able to index about 23,000 records in under three minutes. Assuming you aren't going to make too many typos in your naming, you should be fine just doing the re-indexing. Try timing yo

Re: Best practice for storing relational data in Solr

2008-01-04 Thread Robert Young
Short answer: It depends. Long answer: It depends on whether you want to be able to search on. If you need to search by recruiter name then obviously you'll need to index it, if you don't you only really need to index the most relevent db identifier, then work out the relations from that in MySQL (