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 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, AlbumName] LUCENE 'daft+punk' > order by relevance desc* > > Without the "order by" method performance is good: > explainwithoutorderby.jpg > > Now with "order by": explainwithoutorderby.jpg > > > You can see the order by index unused. Performance decreases dramatically. > > Do you have any idea on how to solve this issue? > > -- > > --- > You received this message because you are subscribed to the Google Groups > "OrientDB" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to orient-database+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
