Re: MySQL queries high when using delta-import

2011-03-14 Thread Bill Bell
You could use clean= false parameter trick then just use query. Thus would reduce the queries by half for deltas. Bill Bell Sent from mobile On Mar 14, 2011, at 8:57 AM, Stefan Matheis wrote: > Robert, > > that may extremly depend on your (sub-)entities, and how you built your > queries. >

Re: MySQL queries high when using delta-import

2011-03-14 Thread Stefan Matheis
Robert, that may extremly depend on your (sub-)entities, and how you built your queries. perhaps http://wiki.apache.org/solr/DataImportHandler#CachedSqlEntityProcessor would help you - like said, depending on your config Regards Stefan 2011/3/14 Robert Gründler : > Hi, > > we have 3 solr cores,

MySQL queries high when using delta-import

2011-03-14 Thread Robert Gründler
Hi, we have 3 solr cores, each of them is running a delta-import every 2 minutes on a MySQL database. We've noticed a significant increase of MySQL queries per second, since we've started the delta updates. Before that, the database server received between 50 and 100 queries per second, si