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:[email protected]]
Gesendet: Freitag, 29. April 2011 08:41
An: [email protected]
Betreff: Re: Is it planned to use Lucene to sort query results?
2011/4/28 Seidel. Robert <[email protected]>:
> 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 * [email protected]
________________________________________________________________
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.
