On 5 December 2012 22:12, Spadez <james_will...@hotmail.com> wrote: > Hi, > > I am looking to import entries to my SOLR server by using the DIH, > connecting to an external postgre SQL server using the JDBC driver. I will > be importing about 50,000 entries each time.
Unless you have a lot of data in each entry, importing 50,000 entries should be pretty trivial. > Is connecting to an external SQL server for my data unreliable or risky, or > is it instead perfrectly reasonable? [...] Reliability is largely a matter of network connectivity, load on the database and Solr servers, and to a lesser extent, on the JDBC driver used (for SQL server, jTDS seemed significantly better to us). Again, for 50,000 entries, these should typically not be of concern. "Risky" in what sense? Are the data sensitive? Regards, Gora
