Erick, Thanks for the pointer. Getting astray from what Vrinda is looking for (sorry about that), what if there are no sub-entities? and no deltaImportQuery passed too. I looked into the code and determine it calculates the deltaImportQuery itself, SQLEntityProcessor:getDeltaImportQuery(..)::126.
Ideally then, a full-import or the delta-import should take similar time to build the docs (fetch next row). I may very well be going entirely wrong here. Amrit Sarkar Search Engineer Lucidworks, Inc. 415-589-9269 www.lucidworks.com Twitter http://twitter.com/lucidworks LinkedIn: https://www.linkedin.com/in/sarkaramrit2 On Thu, Jun 1, 2017 at 1:50 PM, vrindavda <vrinda...@gmail.com> wrote: > Thanks Erick, > > But how do I solve this? I tried creating Stored proc instead of plain > query, but no change in performance. > > For delta import it in processing more documents than the total documents. > In this case delta import is not helping at all, I cannot switch to full > import each time. This was working fine with less data. > > Thank you, > Vrinda Davda > > > > -- > View this message in context: http://lucene.472066.n3. > nabble.com/Number-of-requests-spike-up-when-i-do-the-delta- > Import-tp4338162p4338444.html > Sent from the Solr - User mailing list archive at Nabble.com. >
