jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Seidel. Robert" <Robert.Sei...@aeb.de>
Subject AW: Is it planned to use Lucene to sort query results?
Date Fri, 29 Apr 2011 07:19:32 GMT
Hi,

we use 2.2.1 and I do write about normal SQL2 queries with "order" expression like

queryManager.createQuery("SELECT * FROM [aeb:unstructured] AS RESULT WHERE LOWER([objectType])
LIKE 'country%' ORDER BY [STORAGE_ORDER_NUMBER] DESC", Query.JCR_SQL2);
QueryResult result = q.execute;

The execute leads to QueryEngine>execute which calls QueryEngine>sort which uses Collections.sort,
retrieving all result nodes from the database to be able to compare them (resulting in slow
performance, huge memory consumption).

If you look deeper into the code, you will come to LuceneQueryFactory>execute and JackrabbitIndexSearcher>evaluate
using a new instance of Sort() - that would have been the Lucene sort.

Kindly regards, Robert

-----Ursprüngliche Nachricht-----
Von: Ard Schrijvers [mailto:a.schrijvers@onehippo.com]
Gesendet: Freitag, 29. April 2011 08:41
An: users@jackrabbit.apache.org
Betreff: Re: Is it planned to use Lucene to sort query results?

2011/4/28 Seidel. Robert <Robert.Seidel@aeb.de>:
> Hi,
>
> is it planned to use Lucene to sort query results?

Which queries are you referring to? Lucene has been used to query and
sort results since I first looked at the jackrabbit search impl like 3
or 4 years ago, so I am not sure what part you are looking at now.
Also which version of jackrabbit?

Regards Ard

>
> Collections.sort in QueryEngine is a bad joke, if there are millions of result rows and
you are only interested in the 10 oldest ones.
>
> Kindly regards, Robert
> ________________________________
>
> Logistik und Au?enwirtschaft stehen auf der transport logistic vom 10.-13. Mai 2011 in
M?nchen im Mittelpunkt.
> Ihre Fragen am Stand von AEB. In Halle B2, Stand 405/506.
> Hier k?nnen Sie einen Termin vereinbaren und einen Gewinncode generieren: www.aeb.de/transport-logistic.
> Mit etwas Gl?ck gewinnen Sie vor Ort ein Apple iPad.
>



--
Hippo
Europe  *  Amsterdam  Oosteinde 11  *  1017 WT Amsterdam  *  +31 (0)20 522 4466
USA  * San Francisco 755 Baywood Drive, Second Floor *  Petaluma, CA.
94954 *  +1 877 414 4776 (toll free)
Canada    *   Montréal  5369 Boulevard St-Laurent #430 *  Montréal QC
H2T 1S5  *  +1 (514) 316 8966
www.onehippo.com  *  www.onehippo.org  *  info@onehippo.com
________________________________________________________________
This e-mail may be privileged and/or confidential, and the sender does
not waive any related rights and obligations. Any distribution, use or
copying of this e-mail or the information it contains by other than an
intended recipient is unauthorized. If you received this e-mail in
error, please advise me (by return e-mail or otherwise) immediately.
________________________________

Logistik und Außenwirtschaft stehen auf der transport logistic vom 10.-13. Mai 2011 in München
im Mittelpunkt.
Ihre Fragen am Stand von AEB. In Halle B2, Stand 405/506.
Hier können Sie einen Termin vereinbaren und einen Gewinncode generieren: www.aeb.de/transport-logistic.
Mit etwas Glück gewinnen Sie vor Ort ein Apple iPad.

Mime
View raw message