hi, in a repository with 1 million records
if i execute the query : select * from test:Contracts where test:Id like 'B11111%' it returns 1000 results in about 0.3s but if i execute the query select * from test:Contracts where test:Id like 'B11111%' order by test:Id it returns the same 1000 results but takes 3.5s to calculate. does the order clause affect the hole repository ?? it must'nt take 3.5 to sort only 1000 results. the same problem with sql and jcr-sql2 any tip ? is this a bug in lucene search? -- Jose Hernandez 675599600 Isthari http://www.isthari.com
