Re: Solr, I have perfomance problem for indexing.

2012-06-07 Thread Erick Erickson
You haven't really told us much about what you're doing here. As Lee hints, we don't know much about the details of *how* you are doing this. But unless you're doing something odd, Solr shouldn't be the bottleneck here. Often when a database import is slow, the problem is in the data- acquisition

Re: Solr, I have perfomance problem for indexing.

2012-06-07 Thread Lee Carroll
what is your db schema ? do you need to import all the schema ? (128 joined tables ??) or are the tables all independant ? (if so dump them out and import them in using csv) cheers lee c On 7 June 2012 02:32, Jihyun Suh wrote: > Each table has 35,000 rows. (35 thousands). > I will check the log

Re: Solr, I have perfomance problem for indexing.

2012-06-06 Thread Jihyun Suh
Each table has 35,000 rows. (35 thousands). I will check the log for each step of indexing. I run Solr 3.5. 2012/6/6 Jihyun Suh > I have 128 tables of mysql 5.x and each table have 3,5000 rows. > When I start dataimport(indexing) in Solr, it takes 5 minutes for one > table. > But When Solr ind

Re: Solr, I have perfomance problem for indexing.

2012-06-05 Thread Lance Norskog
Which Solr do you run? On Tue, Jun 5, 2012 at 8:02 PM, Jack Krupansky wrote: > You wrote "3,5000", but is that 35 hundred (3,500) or 35 thousand (35,000)?? > > Your numbers seem far worse than what many people typically see with Solr > and DIH. > > Is the database running on the same machine? > >

Re: Solr, I have perfomance problem for indexing.

2012-06-05 Thread Jack Krupansky
You wrote "3,5000", but is that 35 hundred (3,500) or 35 thousand (35,000)?? Your numbers seem far worse than what many people typically see with Solr and DIH. Is the database running on the same machine? Check the Solr log file to see if some errors (or warnings) might be occurring frequent