On Thu, 2012-07-19 at 12:54 +0200, Spadez wrote: > I want to import any new SQL results onto the server as quickly as possible > so they are searchable but I dont want to overload the server. These are my > new options: > > 1. Devise a script to run when a new SQL item is posted, to immediatly > import only the new SQL record to Solr
Unless you have really complex documents, which does not sound likely for an auction site, 20,000 entries and 100 changes is a tiny index in the Lucene/Solr world. It sounds like you're optimizing prematurely: Go with option 1 and expect updates to take a few seconds without the server straining. - Toke Eskildsen
