Query Execution using Hibernate Search slow for large volume data

1. Create a Batch job to Create 240 million entries in Infinispan with all entries Indexed 2. Execute the following query through hotrod remote client String queryString= "SELECT ACCOUNT_ID,ID,PRODUCT_TYPE,FIRST_CALL,ID,IMEI from com.subex.spark.common.distributedcaching.data.Subscriber where PHONE_NUMBER= '" +prefix+ i+ "' AND STATUS in (1,2) and SUBSCRIBER_TYPE = 0" ; QueryFactory qf = Search.getQueryFactory(distcacheclient.getRemoteCache()); RemoteQuery remoteQuery = new RemoteQuery(qf,(RemoteCacheImpl)distcacheclient.getRemoteCache(), distcacheclient.getSerializationContext(), queryString, 0, ( int )numOfRecords); List<Subscriber> list = remoteQuery.list(); 3. Following Query was executed in Embedded mode String queryString= "SELECT ACCOUNT_ID,ID,PRODUCT_TYPE,FIRST_CALL,ID,IMEI from com.subex.spark.common.distributedcaching.data.Subscriber where " + "PHONE_NUMBER= '" +prefix+ i+ "' AND STATUS in (1,2) and SUBSCRIBER_TYPE = 0" ; QueryFactory qf = org.infinispan.query.Search.getQueryFactory(ispnCacheServer.getCache( "SUBSCRIBER" )); Query query = qf.from( "com.subex.spark.common.distributedcaching.data.Subscriber" ).setProjection( "ACCOUNT_ID" , "ID" , "PRODUCT_TYPE" , "FIRST_CALL" , "ID" , "IMEI" ). having( "PHONE_NUMBER" ).eq(prefix+ i).and().having( "STATUS" ).in(1,2).and().having( "SUBSCRIBER_TYPE" ).eq(0).toBuilder().build(); List<Subscriber> list = query.list(); rs = query.list().iterator(); 4. Hibernate Search Query QueryContextBuilder queryBuilder = searchSession.getSearchFactory().buildQueryBuilder(); Query query = queryBuilder.forEntity(Subscriber.class).get().keyword().onField( "ID" ).matching( Long .parseLong(prefix+i)).createQuery(); org.hibernate.Query hibernateQuery=searchSession.createFullTextQuery(query, Subscriber.class).setProjection( "ACCOUNT_ID" , "ACCOUNT_NAME" , "CONNECTION_TYPE" , "CONTACT_PHONE_NUMBER" , "CURRENT_BALANCE" , "CUST_ALERT_CONTACT_NUMBER" , "CUST_ALERT_EMAIL_ID" , "DATE_OF_BIRTH" , "DEALER_NAME" , "DS_NAME" , "FILE_NAME" , "FIRST_CALL" , "GROUPS" , "PVN" , "HOME_PHONE_NUMBER" , "ID" , "ID_NUMBER" , "IMEI" , "IMSI" , "IS_UPDATE" , "MCN1" , "MCN2" , "MODIFIED_DATE" , "NETWORK_ID" , "NOTIFICATION_GROUPS" , "OFFICE_PHONE_NUMBER" , "OPTIONAL_FIELD_1" , "OPTIONAL_FIELD_10" , "OPTIONAL_FIELD_11" , "OPTIONAL_FIELD_12" , "OPTIONAL_FIELD_13" , "OPTIONAL_FIELD_14" , "OPTIONAL_FIELD_15" , "OPTIONAL_FIELD_2" , "OPTIONAL_FIELD_3" , "OPTIONAL_FIELD_4" , "OPTIONAL_FIELD_5" , "OPTIONAL_FIELD_6" , "OPTIONAL_FIELD_7" , "OPTIONAL_FIELD_8" , "OPTIONAL_FIELD_9" , "PHONE_NUMBER" , "PRODUCT_TYPE" , "QOS" , "SERVICES" , "SERVICE_NUMBER_TYPE" , "SSID" , "STATUS" , "SUBSCRIBER_DOA" , "SUBSCRIBER_TYPE" , "SUBSCRIBER_UID" , "SUBSCRIBER_UID_DOA" ); This contains the list of all fields in the Cache all of which are indexed.