jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jeroen Reijn <j.re...@onehippo.com>
Subject Re: Like database indexes, not lucene idexes
Date Thu, 05 Jan 2012 16:01:27 GMT
Hi,

On Thu, Jan 5, 2012 at 3:17 PM, Yavuz Kavus <yavuzkavus@gmail.com> wrote:

> I am executing a query on a repository, to get all nodes of a specif type.
> There is around 10.000 records of that type and query lasts for 25 seconds.
>
> Sql is someting like this :
> select id, userName, likesCount, talkingAboutCount
> from pageProvider
> order by likesCount asc
>
> when i remove "order by clause", it comes down to 17 seconds.
> isn't it too slow, though there is not where clause?
>

That depends. Are you trying to retrieve those 10.000 nodes as well?
In that case Jackrabbit will by default try to check the nodes with the
AccessManager if the nodes can be read.


>
> and besides, can i add an index for a field, like db index, not search
> index
> to fasten queries whose "where clause" includes that field?
>

not that I know of.

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