in debug mode it writes only 10 because there is a rows parameter which is by default set to 10 make it 100 or so and you should be seeing all docs. But in non-debug mode there is no such parameter
On Sun, Oct 12, 2008 at 11:00 PM, con <[EMAIL PROTECTED]> wrote: > > I wrote a jdbc program to implement the same query. But it is returning all > the responses, 25 nos. > But the solr is still indexing only 10 rows. > Is there any optimization settings by default in the solrconfig.xml that > restricts the responses to 10 ? > thanks > con. > > > > > > Noble Paul നോബിള് नोब्ळ् wrote: >> >> template transformer does not eat up rows. >> >> I am almost sure that the query returns only 10 rows in that case. >> could you write a quick jdbc program and verify that (not the oralce >> client) >> >> everything else looks fine >> >> On Sat, Oct 11, 2008 at 4:52 PM, con <[EMAIL PROTECTED]> wrote: >>> >>> Hi Noble >>> Thanks for your reply >>> >>> In my data-config.xml I have; >>> >>> <entity name="employees" transformer="TemplateTransformer" >>> query="Select >>> EMP_ID , EMP_NAME , NVL (COMMENT ,'-Nil-') as COMMENT from EMPLOYEES"> >>> <field column="rowtype" template="employees" /> >>> <field column="EMP_ID" name="EMP_ID" /> >>> <field column="EMP_NAME" name="EMP_NAME" /> >>> <field column="COMMENT" name="COMMENT" /> >>> </entity> >>> >>> <entity name="customers" transformer="TemplateTransformer" >>> query="Select >>> CUST_ID , CUST_NAME , NVL (COMMENT ,'-Nil-') as COMMENT from CUSTOMERS"> >>> <field column="rowtype" template="customers" /> >>> <field column="CUST_ID" name="CUST_ID /> >>> <field column="CUST_NAME" name="CUST_NAME" /> >>> <field column="COMMENT" name="COMMENT" /> >>> </entity> >>> >>> Whether this, TemplateTransformer, is the one that is restricting the >>> resultset count to 10? >>> Where can I find it out? >>> I need this TemplateTransformer because I want to query the responses of >>> either one of these at a time using the URL like, >>> >>> http://localhost:8983/solr/select/?q=(Bob%20AND%20rowtype:customers)&version=2.2&start=0&rows=10&indent=on&wt=json >>> >>> I tried in the debug mode: >>> (http://localhost:8983/solr/dataimport?command=full-import&debug=on&verbose=on) >>> , But it is not all mentioning anything after the 10th document. >>> >>> >>> Thanks and regards >>> con >>> >>> >>> >>> Noble Paul നോബിള് नोब्ळ् wrote: >>>> >>>> The DIH status says 10 rows which means only 10 rows got fetched for >>>> that query. Do you have any custom transformers which eats up rows? >>>> >>>> Try the debug page of DIH and see what is happening to the rest of the >>>> rows. >>>> >>>> >>>> >>>> On Fri, Oct 10, 2008 at 5:32 PM, con <[EMAIL PROTECTED]> wrote: >>>>> >>>>> A simple question: >>>>> I performed the following steps to index data from a oracle db to solr >>>>> index >>>>> and then search: >>>>> a) I have the configurations for indexing data from a oracle db >>>>> b) started the server. >>>>> c) Done a full-import: >>>>> http://localhost:8983/solr/dataimport?command=full-import >>>>> >>>>> But when I do a search using http://localhost:8983/solr/select/?q=.... >>>>> Not all the result sets that matches the search string are displayed. >>>>> >>>>> 1) Is the above steps enough for getting db values to solr index? >>>>> My configurations (data-config.xml and schema.xml )are quite correct >>>>> because >>>>> I am getting SOME of the result sets as search result(not all). >>>>> 2) Is there some value in sorconfig.xml, or some other files that >>>>> limits >>>>> the >>>>> number of items being indexed? [For the time being I have only a few >>>>> hundreds of records in my db. ] >>>>> The query that I am specifying in data-config yields around 25 results >>>>> if >>>>> i >>>>> execute it in a oracle client, where as the status of full-import is >>>>> something like: >>>>> <str name="status">idle</str> >>>>> <str name="importResponse">Configuration Re-loaded sucessfully</str> >>>>> <lst name="statusMessages"> >>>>> <str name="Total Requests made to DataSource">1</str> >>>>> <str name="Total Rows Fetched">10</str> >>>>> <str name="Total Documents Skipped">0</str> >>>>> <str name="Full Dump Started">2008-10-10 17:29:03</str> >>>>> <str name="Time taken ">0:0:0.513</str> >>>>> </lst> >>>>> >>>>> >>>>> >>>>> -- >>>>> View this message in context: >>>>> http://www.nabble.com/Solr-indexing-not-taking-all-values-from-DB.-tp19916938p19916938.html >>>>> Sent from the Solr - User mailing list archive at Nabble.com. >>>>> >>>>> >>>> >>>> >>>> >>>> -- >>>> --Noble Paul >>>> >>>> >>> >>> -- >>> View this message in context: >>> http://www.nabble.com/Solr-indexing-not-taking-all-values-from-DB.-tp19916938p19931736.html >>> Sent from the Solr - User mailing list archive at Nabble.com. >>> >>> >> >> >> >> -- >> --Noble Paul >> >> > > -- > View this message in context: > http://www.nabble.com/Solr-indexing-not-taking-all-values-from-DB.-tp19916938p19943817.html > Sent from the Solr - User mailing list archive at Nabble.com. > > -- --Noble Paul
