Re: [orientdb] How to speed up ORDER BY

Hi Luigi, (I am a co-worker of Hung, the original author of this post) Thank you very much for your answer. Creating the following index really improved the performance of that query (without @rid in ORDER BY clause). CREATE INDEX Task.PriorityDueTime ON Task (Priority, DueTime) NOTUNIQUE

[orientdb] Re: orient db disconnect/timeout

Hi Mihai, the reasons of the issues can be diffferent (e.g. network problems) but similar issues have been fixed in the latest OrientDB versions. Could you try to update to the latest 2.1.16 ? Thanks -- --- You received this message because you are subscribed to the Google Groups

Re: [orientdb] How to speed up ORDER BY

Hi, The problem here is that the result set can be sorted using the index when you define ORDER BY Priority DESC, but when you add other conditions like ORDER BY Priority DESC, @rid ASC then the index becomes useless and the result set has to be sorted in memory. For the second case (ORDER BY

Re: [orientdb] Database as a single file?

Thank you for the quick reply. I am not sure whether or not its a show-stopper for me, but for a desktop app, a single file is a useful feature. For instance H2 have the facility to support a database in a zip through its jdbc connector (jdbc:h2:zip:!/). cheers > -- --- You received

[orientdb] Re: orient db disconnect/timeout

The same situation happens if we use the database from the same server in which the database is running, with the difference that the first warning is about Channel closed instead of Stream closed: WARNING [com.orientechnologies.orient.client.remote.OStorageRemote] (default task-4) Caught I/O

[orientdb] orient db disconnect/timeout

Hello, I'm having a strange issue with orientdb getting disconnected: after a longer period of inactivity ( ~3hours ? ), when we try to insert/register a new user, the attempt hangs on commit. There is no error, but a warnings in the server log: > WARNING

Re: [orientdb] Re: oetl problems loading csv data to a document database

Luca, Do you have a solution for this problem? The Etl programs are not working for document databases. Op dinsdag 26 april 2016 10:48:58 UTC+2 schreef Luc Evers: > > Alessandro, > >Thanks for the test! > Seems a problem for document databases. > >Luc. > >

[orientdb] Re: Distributed mode with multicast enabled don't work.

+ The machine can handle multicast. Op zondag 20 maart 2016 10:19:09 UTC+1 schreef Luc Evers: > > Info > >OrientDB version: 2.1.13 > >Test: 3 servers on the same lan, running ubuntu (14.04). > OrientDB (root password installed), we didn't touch any > configuration or

Re: [orientdb] Re: Distributed mode with multicast enabled don't work.

No, multicast enabled="true" Op zondag 24 april 2016 17:01:25 UTC+2 schreef l.garulli: > > Hi Luc, > I guess in the non working cfg, the multicast is simply off. > > Best Regards, > > Luca Garulli > Founder & CEO > OrientDB > > > On 24 April 2016 at 11:24, Luc Evers

Re: [orientdb] Database as a single file?

Hi David, In current release this is not supported, and structurally it's not easy to do, so I'm afraid it will hardly enter in the roadmap (but things can change of course...) Thanks Luigi 2016-05-04 1:15 GMT+02:00 : > This might be a stupid question, but is it possible