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.
