[infinispan-issues] [JBoss JIRA] (ISPN-5452) Query Execution using Hibernate Search slow for large volume data

[ https://issues.jboss.org/browse/ISPN-5452?page=com.atlassian.jira.plugin.... ] Prashant Thakur commented on ISPN-5452: --------------------------------------- Hi Sanne, We have been doing some profiling and changes to improve around BuildSearcher piece. We observed that if codec is changed to org.apache.lucene.codecs.bloom for fields which are discrete there is huge dip in buildSearcher part. Can you please look at providing this as configuration with other annotations. We also see that most part of time is spent in Parsing If we have something like bind variables in Oracle and reuse the query plan with change in just parameter it would save alot of time and we can expect 2x improvement than current speed. I saw a ticket being raised for same https://issues.jboss.org/browse/ISPN-5414 . If there is some work already in progress and you would wish us to contribute in testing or coding please let us know . This is an absolute must for achieving the performance figures and we would like to avoid duplication of effort. Regarding 2nd question Test run have the same number of Keys and Same number of queries. So we are sure multiple queries are not fired. For sample data I am attaching the profiling info in attached excel sheet where we see time spent in various phases. Please let us know if you require extra information -- This message was sent by Atlassian JIRA (v6.3.15#6346)