Re: [orientdb] Lucene query with sorting. Performance problem

Hi Mohammad, Lucene indexes do not provide ordering (or better, they return results based on their score, but it's not what you need). What you can do here is define an additional NOTUNIQUE index on "name", this will do the job Thanks Luigi 2018-03-31 23:45 GMT+02:00 Mohammad Hossein Ganjyar <

Re: [orientdb] Lucene query with sorting. Performance problem

I have this problem with orientdb v2.2.31. I have vertex Users with properties id (no index), name (lucene index), family(lucene index). My quesry is : SELECT @rid, name , family FROM profiles order by name asc limit 10 This query is very slow (exc in ~17 seconds). Do you best idea? thanks On

[orientdb] Lucene query with sorting. Performance problem

Hi, I have a 'fulltext lucene' index to do a quick search on multiple fields. It is working properly. Now i would like to sort these results through a numeric field. Therefore, I created a 'notunique' index to this field. You can find below my request : *select from Tracks [Title, ArtistName,

Re: [orientdb] Lucene query with sorting. Performance problem

Hi Etienne can you try to remove the not unique index and paste here the explain of *select from Tracks [Title, ArtistName, AlbumName] LUCENE 'daft+punk' order by relevance desc* Thanks Enrico 2014-09-26 11:30 GMT+02:00 Etienne Crinier etienne.crin...@gmail.com: Hi, I have a 'fulltext

Re: [orientdb] Lucene query with sorting. Performance problem

Hi, Thank you for your answer. In attachment, the result of explain without index Thanks Le vendredi 26 septembre 2014 11:50:12 UTC+2, Enrico Risa a écrit : Hi Etienne can you try to remove the not unique index and paste here the explain of *select from Tracks [Title, ArtistName,