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 <rob...@dubture.com>: > 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, > since the Delta-Imports the query count has rised up to 100 to 200 queries > per second. > > I've temporarily disabled the delta imports for 2 hours, and the queries per > second immediately > decreased again to 50-100 per second. > > I followed the Wiki entry which only uses one Query for the delta import: > > http://wiki.apache.org/solr/DataImportHandlerDeltaQueryViaFullImport > > I did not expect the queries per seconds to the database increase that high, > so i'm wondering > if others experienced similar issues. > > > cheers > > -robert > > >
