Back then we wrote a convert class that just checks if the SQL2 query could be rewritten to a SQL1 query and then does it automatically.
regards, Lukas > On 30 Jan 2015, at 16:17, cfalletta <[email protected]> wrote: > > Hi all, > > Thanks for taking the time to look into my problem. > > Your remarks about SQL2 led me to test the xpath/SQL1 versions of the same > query. > That was a serious blast... I can't say for sure for production environment, > but we have tested a search on 180.000 documents and the query took ~300ms > (including the count query !). > I think we have a lead here. We'll go from there and find a way to migrate > our SQL2 queries to SQL1 > > Cédric > > > > -- > View this message in context: > http://jackrabbit.510166.n4.nabble.com/really-poor-search-performance-tp4661920p4661936.html > Sent from the Jackrabbit - Users mailing list archive at Nabble.com.
