Thanks James.
We have tried the following options *(individually)* including the one you
suggested,
1.selectMethod=cursor
2. batchSize=-1
3.responseBuffering=adaptive
But the indexing process doesn't seem to be improving at all. When we try to
index set of 500 rows it works well gets completed
:43 AM
To: solr-user@lucene.apache.org
Subject: RE: SOLR - Unable to execute query error - DIH
Thanks James.
We have tried the following options *(individually)* including the one you
suggested,
1.selectMethod=cursor
2. batchSize=-1
3.responseBuffering=adaptive
But the indexing process doesn't
: Thursday, March 28, 2013 2:43 AM
To: solr-user@lucene.apache.org
Subject: RE: SOLR - Unable to execute query error - DIH
Thanks James.
We have tried the following options *(individually)* including the one you
suggested,
1.selectMethod=cursor
2. batchSize=-1
3.responseBuffering=adaptive
: I am trying to index data from SQL Server view to the SOLR using the DIH
Have you ruled out the view itself being the bottle neck?
Try running whatever command line SQLServer client exists on your SOLR
server to connect remotely to your existing SQL server and run select *
from view and
In context of the above scenario, when i try to index set of 500 rows, it
fetches and indexes around 400 odd rows and then it shows no progress and
keeps on executing. What can be the possible cause of this issue? If
possible, please do share if you guys have gone through such scenario with
the
With MS SqlServer, try adding selectMethod=cursor to your conenction string
and set your batch size to a reasonable amount (possibly just omit it and DIH
has a default value it will use.)
James Dyer
Ingram Content Group
(615) 213-4311
-Original Message-
From: kobe.free.wo...@gmail.com