jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From JOSE FELIX HERNANDEZ BARRIO <jose.hernan...@isthari.com>
Subject query performance
Date Wed, 23 Jun 2010 09:26:17 GMT
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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message