Hello Robert, On Fri, Apr 29, 2011 at 9:19 AM, Seidel. Robert <[email protected]> wrote: > 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).
I am not sure about SQL2, and knew it did have quite bad performance. I am not sure since which version of Jackrabbit this is improved? Any one? Either way, if you can use XPATH or SQL, the sorting it done by Lucene Regards Ard > > 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. > -- 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.
