Solr 1.4 very slow - 60.000 documents

2012-08-30 Thread Andre Lopes
Hi, I've a Solr 1.4 with about 60.000 documents but is getting very slow in the searches. The website have usually very very few users. The machine have 512MB Ram and I'm serving with Nginx one Python based web app that is very low weight. How can I search for the cause of the Solr slowdown? Any

Re: How to configure schema.xml to take in account two database tables?

2012-08-05 Thread Andre Lopes
Hi, I've found what's wrong. By default the query was returning 10 results. With "rows" I can now return more than 10: http://localhost:8983/solr/select?q=*:*&rows=400 Thanks for the help. From here I will try do dig deeper. Best Regards, On Sun, Aug 5, 2012 at 7:2

Re: How to configure schema.xml to take in account two database tables?

2012-08-05 Thread Andre Lopes
> >> If possible, identify one input record that isn't in the 9 results but >> should be and verify its id. >> >> >> -- Jack Krupansky >> >> -Original Message- From: Andre Lopes >> Sent: Sunday, August 05, 2012 1:31 PM >> To: s

Re: How to configure schema.xml to take in account two database tables?

2012-08-05 Thread Andre Lopes
olr with this query "http://localhost:8983/solr/select?q=*:*"; I only get 9 results. I've used a very basic schema.xml: id Some clues on what I'm doing wrong? Best Regards, On Sun, Aug 5, 2012 at 1:19 PM, Gora Mo

How to configure schema.xml to take in account two database tables?

2012-08-05 Thread Andre Lopes
Hi, I'm new to Solr. I've take some reads about how it works, but I can't find a clue for my specific situation. Here is my case. I've 2 database tables that I need to add to the index, but they are related. One entry in the table "clients" could have more than one entry in the table "contacts".

Re: Tools for schema.xml generation and to import from a database

2012-07-30 Thread Andre Lopes
that keeps events from happening all > at once. Lately, it doesn't seem to be working. (Anonymous - via GTD > book) > > > On Sun, Jul 29, 2012 at 3:45 PM, Andre Lopes wrote: >> Hi, >> >> I'm new to Solr. I've installed 3.6.1 but I'm a little b

Tools for schema.xml generation and to import from a database

2012-07-29 Thread Andre Lopes
Hi, I'm new to Solr. I've installed 3.6.1 but I'm a little bit confused about what and how to do next. I will use the Jetty version for now. Two poinst I need to know: 1 - I've 2 views that I would like to import to Solr. I think I must do a schema.xml and then import data to that schema. I'm co