DataStax Support Forums » Topic: Solr query faster via curl than thru cql

DataStax Support Forums » Topic: Solr query faster via curl than thru cql http://www.datastax.com/support-forums/topic/solr-query-faster-via-curl-than-thru-cql Software, Support, and Training for Apache Cassandra en-US Fri, 24 May 2013 14:31:52 +0000 http://bbpress.org/?v=1.0.3 <![CDATA[Search]]> q http://www.datastax.com/support-forums/search.php Anonymous on "Solr query faster via curl than thru cql" http://www.datastax.com/support-forums/topic/solr-query-faster-via-curl-than-thru-cql#post-1655 Tue, 17 Apr 2012 17:05:45 +0000 Anonymous 1655@http://www.datastax.com/support-forums/ Also the queries through CQL does not seem to be using Solr queryResultCache. Rerun of the same query through curl has almost instataneous response back. Not so through CQL, rerun takes about the same time again. Anything I am missing ? tjake on "Solr query faster via curl than thru cql" http://www.datastax.com/support-forums/topic/solr-query-faster-via-curl-than-thru-cql#post-1638 Mon, 16 Apr 2012 19:53:15 +0000 tjake 1638@http://www.datastax.com/support-forums/ I don't see any warming queries in your new config (EXAMPLE):  <listener event="newSearcher" class="solr.QuerySenderListener"> <arr name="queries"> <lst><str name="q">solr</str><str name="sort">price asc</str></lst> <lst><str name="q">rocks</str><str name="sort">weight asc</str></lst> </arr> </listener> <listener event="firstSearcher" class="solr.QuerySenderListener"> <arr name="queries"> <lst> <str name="q">static firstSearcher warming in solrconfig.xml</str> </lst> </arr> </listener> Also you should set <useColdSearcher>false</useColdSearcher> Anonymous on "Solr query faster via curl than thru cql" http://www.datastax.com/support-forums/topic/solr-query-faster-via-curl-than-thru-cql#post-1637 Mon, 16 Apr 2012 19:50:09 +0000 Anonymous 1637@http://www.datastax.com/support-forums/ It is just a single node. Number of rows are in millions. It takes about 6 seconds thru CQL and about 3 seconds thru curl. tjake on "Solr query faster via curl than thru cql" http://www.datastax.com/support-forums/topic/solr-query-faster-via-curl-than-thru-cql#post-1636 Mon, 16 Apr 2012 19:46:13 +0000 tjake 1636@http://www.datastax.com/support-forums/ How many nodes? The search through cql uses a different approach than over solr so if you have many nodes it contacts each node sequentially from cql. The data is not stored twice only the index data "postings" are stored in Solr files the raw field data is accessed from Cassandra. Anonymous on "Solr query faster via curl than thru cql" http://www.datastax.com/support-forums/topic/solr-query-faster-via-curl-than-thru-cql#post-1635 Mon, 16 Apr 2012 19:39:41 +0000 Anonymous 1635@http://www.datastax.com/support-forums/ I have a solr index on a large CF. The solr query (curl) is much faster than thru cql. What could be the reason ? Also, is the data/index stored twice ? In cassandra sstables as well as solr files ? Thanks.