Francis, So it could easily be that your QA and PROD DBs are really just simply different (different amount of data, different network speed, different hardware...)
Otis -- Sematext -- http://sematext.com/ -- Lucene - Solr - Nutch ----- Original Message ---- > From: Francis Yakin <fya...@liquid.com> > To: "solr-user@lucene.apache.org" <solr-user@lucene.apache.org> > Sent: Friday, June 19, 2009 10:39:48 PM > Subject: RE: Slowness during submit the index > > * is the java version the same on both machines (QA vs. PROD) - YES > * are the same java parameters being used on both machines - YES > * is the connection to the DB the same on both machines - Not sure, > need > to ask the network guy > * are both the PROD and QA DB servers the same and are both DB instances the > same - they are not from the same DB > > -----Original Message----- > From: Otis Gospodnetic [mailto:otis_gospodne...@yahoo.com] > Sent: Friday, June 19, 2009 6:23 PM > To: solr-user@lucene.apache.org > Subject: Re: Slowness during submit the index > > > Francis, > > I'm not sure if I understood your email correctly, but I think you are saying > you are indexing your DB content into a Solr index. If this is correct, here > are things to look at: > * is the java version the same on both machines (QA vs. PROD) > * are the same java parameters being used on both machines > * is the connection to the DB the same on both machines > * are both the PROD and QA DB servers the same and are both DB instances the > same > ... > > > Otis > -- > Sematext -- http://sematext.com/ -- Lucene - Solr - Nutch > > > > ----- Original Message ---- > > From: Francis Yakin > > To: "solr-user@lucene.apache.org" > > Sent: Friday, June 19, 2009 5:27:59 PM > > Subject: Slowness during submit the index > > > > > > We are experiencing slowness during reloading/resubmitting index from > > Database > > to the master. > > > > We have two environments: > > > > QA and Prod. > > > > The slowness is happened only in Production but not in QA. > > > > It only takes one hours to reload 2.5Mil indexes compare 5-6 hours to load > > the > > same size of index in Prod. > > > > I checked both the config files in QA and Prod, they are all identical, > except: > > > > > > In QA: > > false > > In Prod: > > true > > > > I believe that we use "http" protocol reload/submit the index from Database > > to > > Solr Master. > > I did test copying big files thru network from database to the solr box, I > don't > > see any issue. > > > > We are running solr 1.2 > > > > Any inputs will be much appreciated.