Hello, I have a problem, I'm working with Solr 3.5, with a index that has 8.000.000 of documents (13Gb), each document has a lot of fields, I include the schema at bottom the message for more information.
The query time is very high, a simple query has a query time of 300-1.000 ms, and a complex query to 10.000 ms. I have a master, and 6 slaves, they are been syncronized every 10 minutes. And the index always is optimized. What can I do? - I think that cache system is working ok, when I do the same query two times, the query time decrease to 0 ms. Here a example of query, there are any incorrect o anything that can I change? http://xxx:8893/solr/candidate/select/?q=+(IdCandidateStatus:2)+(IdCobranded:3)+(IdLocation1:12))+(LastLoginDate:[2011-08-26T00:00:00Z TO 2012-08-28T00:00:00Z]) *Schema:* <field name="IdCandidate" type="slong" indexed="true" stored="true" required="true" /> <field name="IdUser" type="slong" indexed="true" stored="true" required="true" /> <field name="Email" type="string" indexed="true" stored="true" required="true" /> <field name="Name" type="string" indexed="true" stored="true" required="true" /> <field name="NameFormated" type="alphaOnlySort" indexed="true" stored="true"/> <field name="Surname" type="string" indexed="true" stored="true" required="true" /> <field name="SurnameFormated" type="alphaOnlySort" indexed="true" stored="true"/> <field name="IdSex" type="string" indexed="true" stored="true" required="true" /> <field name="IdWorkingHours" type="sint" indexed="true" stored="true" required="true" /> <field name="IdContractWorkType" type="sint" indexed="true" stored="true" required="true" /> <field name="IdLocation1" type="sint" indexed="true" stored="true" required="true" /> <field name="IdLocation2" type="sint" indexed="true" stored="true" required="true" /> <field name="Location2" type="string" indexed="true" stored="true" required="true" /> <field name="IdLocation3" type="slong" indexed="true" stored="true" required="true" /> <field name="IdLocation4" type="slong" indexed="true" stored="true" required="true" /> <field name="Location4" type="string" indexed="true" stored="true" required="true" /> <field name="IdLocation5" type="slong" indexed="true" stored="true" required="true" /> <field name="Location5" type="string" indexed="true" stored="true" required="true" /> <field name="IdRegion1" type="slong" indexed="true" stored="true" required="true" /> <field name="Region1" type="string" indexed="true" stored="true" required="true" /> <field name="IdRegion2" type="slong" indexed="true" stored="true" required="true" /> <field name="Region2" type="string" indexed="true" stored="true" required="true" /> <field name="LastLoginDate" type="tdate" indexed="true" stored="true" required="true" /> <field name="BirthDate" type="tdate" indexed="true" stored="true" required="true" /> <field name="InsertDate" type="tdate" indexed="true" stored="true" required="true" /> <field name="ModifyDate" type="tdate" indexed="true" stored="true" required="true" /> <field name="IdModifyRangeDate" type="sint" indexed="true" stored="true" required="true" /> <field name="Age" type="sint" indexed="true" stored="true" required="true" /> <field name="IdAgeRange" type="sint" indexed="true" stored="true" required="true" /> <field name="Travel" type="sint" indexed="true" stored="true" required="true" /> <field name="ChangeResidence" type="sint" indexed="true" stored="true" required="true" /> <field name="IdEmployed" type="sint" indexed="true" stored="true" required="true" /> <field name="SalaryMax" type="sdouble" indexed="true" stored="true" required="true" /> <field name="SalaryMin" type="sdouble" indexed="true" stored="true" required="true" /> <field name="IdSalaryRange" type="sint" indexed="true" stored="true" required="true" /> <field name="IdPreferenceManagerialLevelMin" type="sint" indexed="true" stored="true" required="true" /> <field name="IdPreferenceManagerialLevelMax" type="sint" indexed="true" stored="true" required="true" /> <field name="IdStudie1Max" type="sint" indexed="true" stored="true" required="true" /> <field name="IdCategory2Last" type="sint" indexed="true" stored="true" required="true" /> <field name="Category2Last" type="string" indexed="true" stored="true" required="true" /> <field name="Category2LastFormated" type="alphaOnlySort" indexed="true" stored="true" /> <field name="IdCategory1Last" type="sint" indexed="true" stored="true" required="true" /> <field name="IdExperienceTime" type="sint" indexed="true" stored="true" required="true" /> <field name="IdExperienceRange" type="sint" indexed="true" stored="true" required="true" /> <field name="IsDeficiency" type="string" indexed="true" stored="true" required="true" /> <field name="IdStudie1" type="sint" indexed="true" stored="true" required="false" multiValued="true" /> <field name="IdStudie2" type="sint" indexed="true" stored="true" required="false" multiValued="true" /> <field name="IdStudie2Status" type="sint" indexed="true" stored="true" required="false" multiValued="true" /> <field name="IdLanguage" type="sint" indexed="true" stored="true" required="false" multiValued="true" /> <field name="IdKnowledge1" type="sint" indexed="true" stored="true" required="false" multiValued="true" /> <field name="IdKnowledge2" type="sint" indexed="true" stored="true" required="false" multiValued="true" /> <field name="IdDeficiency1" type="sint" indexed="true" stored="true" required="false" multiValued="true" /> <field name="IdDeficiency2" type="sint" indexed="true" stored="true" required="false" multiValued="true" /> <field name="IdCategory1" type="sint" indexed="true" stored="true" required="false" multiValued="true" /> <field name="IdCategory2" type="sint" indexed="true" stored="true" required="false" multiValued="true" /> <field name="IdCategory2Latest" type="sint" indexed="true" stored="true" required="false" multiValued="true" /> <field name="IdPreferenceCategory1" type="sint" indexed="true" stored="true" required="false" multiValued="true" /> <field name="IdPreferenceCategory2" type="sint" indexed="true" stored="true" required="false" multiValued="true" /> <field name="IdLicense" type="sint" indexed="true" stored="true" required="false" multiValued="true" /> <field name="IdVehicle" type="sint" indexed="true" stored="true" required="false" multiValued="true" /> <field name="Phone1" type="string" indexed="true" stored="true" required="true" /> <field name="Phone2" type="string" indexed="true" stored="true" required="true" /> <field name="HasPhoto" type="string" indexed="true" stored="true" required="true" /> <field name="Photo" type="string" indexed="true" stored="true" required="true" /> <field name="StudieCentreLast" type="string" indexed="true" stored="true" required="true" /> <field name="IdManagerialLevelMax" type="sint" indexed="true" stored="true" required="true" /> <field name="IdManagerialLevel" type="sint" indexed="true" stored="true" required="false" multiValued="true" /> <field name="CEP" type="string" indexed="true" stored="true" required="true" /> <field name="Complement" type="string" indexed="true" stored="true" required="true" /> <field name="DeficiencyInformation" type="string" indexed="true" stored="true" required="true" /> <field name="Employed" type="string" indexed="true" stored="true" required="true" /> <field name="HasWord" type="string" indexed="true" stored="true" required="true" /> <field name="ContractWorkType" type="string" indexed="true" stored="true" required="true" /> <field name="ExperienceRange" type="string" indexed="true" stored="true" required="true" /> <field name="Location1" type="string" indexed="true" stored="true" required="true" /> <field name="Location2Short" type="string" indexed="true" stored="true" required="true" /> <field name="PreferenceManagerialLevelMin" type="string" indexed="true" stored="true" required="true" /> <field name="PreferenceManagerialLevelMax" type="string" indexed="true" stored="true" required="true" /> <field name="IdMaritalStatus" type="string" indexed="true" stored="true" required="true" /> <field name="MaritalStatus" type="string" indexed="true" stored="true" required="true" /> <field name="IdNationality" type="sint" indexed="true" stored="true" required="true" /> <field name="Nationality" type="string" indexed="true" stored="true" required="true" /> <field name="IdSalaryType" type="sint" indexed="true" stored="true" required="true" /> <field name="SalaryType" type="string" indexed="true" stored="true" required="true" /> <field name="Sex" type="string" indexed="true" stored="true" required="true" /> <field name="Studie1Max" type="string" indexed="true" stored="true" required="true" /> <field name="IdVisibility" type="string" indexed="true" stored="true" required="true" /> <field name="WorkingHours" type="string" indexed="true" stored="true" required="true" /> <field name="Number" type="sint" indexed="true" stored="true" required="true" /> <field name="ProductCode" type="string" indexed="true" stored="true" required="true" /> <field name="IdLanguageLevel" type="string" indexed="true" stored="true" required="false" multiValued="true" /> <field name="Fti" type="text" indexed="true" stored="false" required="true" /> <field name="Latitude" type="double" indexed="true" stored="true" required="true" /> <field name="Longitude" type="double" indexed="true" stored="true" required="true" /> <field name="lat" type="double" indexed="true" stored="true" required="true" multiValued="false"/> <field name="lng" type="double" indexed="true" stored="true" required="true" multiValued="false"/> <field name="location_latlng" type="location" indexed="true" stored="true" required="true"/> <field name="IdCobranded" type="sint" indexed="true" stored="true" required="false" multiValued="true" /> <field name="IdCandidateStatus" type="sint" indexed="true" stored="true" required="true" /> <field name="IdManagerialLevelLatest" type="sint" indexed="true" stored="true" required="false" multiValued="true" /> <dynamicField name="*_coordinate" type="tdouble" indexed="true" stored="false"/> *Solconfig.xml:* <luceneMatchVersion>LUCENE_35</luceneMatchVersion> ... <directoryFactory name="DirectoryFactory" class="${solr.directoryFactory:solr.StandardDirectoryFactory}"/> <useCompoundFile>false</useCompoundFile> <ramBufferSizeMB>32</ramBufferSizeMB> <mergeFactor>10</mergeFactor> <unlockOnStartup>false</unlockOnStartup> <reopenReaders>true</reopenReaders> ... <maxBooleanClauses>131072</maxBooleanClauses> <filterCache class="solr.FastLRUCache" size="262144" initialSize="8048" autowarmCount="8048"/><queryResultCache class="solr.LRUCache" size="262144" initialSize="8048" autowarmCount="8048"/><documentCache class="solr.LRUCache" size="262144" initialSize="8048" autowarmCount="8048"/><enableLazyFieldLoading>true</enableLazyFieldLoading><queryResultWindowSize>60</queryResultWindowSize> <queryResultMaxDocsCached>200</queryResultMaxDocsCached> ... <useColdSearcher>false</useColdSearcher> <maxWarmingSearchers>2</maxWarmingSearchers> -- View this message in context: http://lucene.472066.n3.nabble.com/Query-Time-problem-on-Big-Index-Solr-3-5-tp4003660.html Sent from the Solr - User mailing list archive at Nabble.com.