Re: [orientdb] Kafka Sync Connect
Hi Sanju, Thanks for the connector, I'm sure somebody will use it. Best Regards, Luca Garulli Founder OrientDB <http://orientdb.com/> On Wed, Feb 7, 2018 at 7:49 PM, Sanju Thomas wrote: > Hey everyone, I recently wrote a kafka connect orientdb (sync). Please > refer https://github.com/sanjuthomas/kafka-connect-orientdb more details. > If anyone would like to collaborate to make it better, please let me know. > Looking forward to hearing from the community. > > -- > > --- > 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.
Re: [orientdb] Best way to do SQL UPDATE when reference to target record
Hi Eric,
With v3.0 you can avoid the eval and doing:
UPDATE #25:0 SET publish = expires + 2
Best Regards,
Luca Garulli
Founder OrientDB <http://orientdb.com/>
On Sat, Jan 20, 2018 at 9:46 PM, Eric24 wrote:
> I'm running a query that sets a field in a target record to a calculated
> value based on another field in that same record. This is a simplified
> version of my query:
>
> UPDATE #25:0 SET publish = eval('@this.expires + 2')
>
> This works, but I just wanted to see if using the eval() function in this
> way was the best/preferred way to do this.
>
> --
>
> ---
> 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.
[orientdb] [Job] Hiring Developers & Tester in Serbia
Hi guys, We're looking for 3 engineers to hire in Serbia, 2 developers and 1 tester. If you're using OrientDB and you live in Serbia (sorry, only Serbia this time), well, you're very lucky because you can apply for a job at OrientDB! Thanks. Best Regards, Luca Garulli VP OrientDB <http://orientdb.com/> -- --- 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.
Re: [orientdb] Re: [Breaking News] CallidusCloud Acquires OrientDB, the Leading Multi-Model Database Technology
Hi Mike, This is not the case. We would never accept to sell the company to a buyer that doesn't want to invest into the product. Even if it's true that Callidus Cloud uses OrientDB for a few mission-critical projects, the plans are not only to continue the development of OrientDB Open Source and Commercial versions but also to expand OrientDB. Soon will be announced important news and features. I hope to have answered to all your questions, fears and doubts :-) Best Regards, Luca Garulli VP OrientDB <http://orientdb.com/> On 23 October 2017 at 04:57, wrote: > Would like to know the reason Callidus Cloud bought OrientDB, other than > an investment. I don't see any previous transactions that they have made > that would help us figure out the future of OrientDB. Would really > appreciate this cleared up. > > My guess is that they want to drive the project to their use case using a > very good DBMS. Everyone elses needs or wants will be lower priority. > > Mike > > On Friday, September 22, 2017 at 7:21:51 PM UTC-4, l.garulli wrote: >> >> Hi all, >> >> OrientDB is here to stay. CallidusCloud bought OrientDB as an investment >> in the Graph and Multi-Model technology because they believe this is the >> best technology in the DBMS world. >> >> In the last months, we've seen the closing of some of the DBMS companies >> that weren't able to be sustainable after years (Basho, RethinkDB, etc). >> I'm sure it has been a pain for their clients that have seen their >> investments failing and a migration to another DBMS is a very expensive >> thing. >> >> Until the last week, OrientDB was a small player, but profitable, in the >> crowded DBMS market. Thanks to CallidusCloud (a public company on NASDAQ), >> OrientDB is now the most solid company in the NoSQL space. >> >> So this is a good news for both clients and users! >> >> OrientDB Community Enterprise *remains Open Source with the same Apache >> 2 license*. OrientDB Enterprise Edition remains commercial. *All the >> clients continue to be supported*. >> >> I hope this responded to your concerns. >> >> Best Regards, >> >> Luca Garulli >> VP OrientDB >> >> >> On 22 September 2017 at 21:58, Tielman Van Vleck wrote: >> >>> True, but Oracle understands databases. Luca (we met in Austin last >>> year): you will have to fight hard for autonomy and constantly prove the >>> relevance of OrientDB within a company with other priorities. Remember what >>> happened to CompuServe after H&R Block bought them - Block intended to keep >>> the product alive, but really bought them for their computing hardware and >>> wouldn't give them the capital needed to compete against AOL's marketing. >>> Oops... don't let CC forget that story! >>> >>> -Tielman >>> >>> >>> On Friday, September 22, 2017 at 1:24:37 PM UTC-4, ad...@cs.miami.edu >>> wrote: >>>> >>>> >>We all remember the path mysql took, after oracle acquired it. >>>> >>>> I am not a heavy mysql user, but I don't think mysql took a terrible >>>> turn after oracle. Mysql still seems to be aviable when I want to install >>>> it, there is still a large communit support network, and it more less works >>>> as expected, but perhaps those who are more invested in mysql will view the >>>> situation different. >>>> >>>> -Adam >>>> >>>> On Friday, September 22, 2017 at 9:42:49 AM UTC-4, Manabu Tokunaga >>>> wrote: >>>>> >>>>> Interesting discussions. I have been in many situations where "I've >>>>> been acquired. Everything discussed here is a very legitimate customer >>>>> concern and hope that there will be official and confirmed answers from >>>>> the >>>>> new company. >>>>> >>>>> In terms of the community aspect of it, we know, for example, there >>>>> are OpenJDK vs Oracle Java and MariaDB vs mySQL type situations where they >>>>> are functionally compatible forks derived from the acquired base. If this >>>>> is possible, then as a community, we have protection. >>>>> >>>> -- >>> >>> --- >>> 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-databa...@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. > -- --- 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.
Re: [orientdb] Re: [Breaking News] CallidusCloud Acquires OrientDB, the Leading Multi-Model Database Technology
Hi Hristo, Sorry for the delay. - All OrientDB features currently available in the Community edition will stay there. The only feature will be moved to the Enterprise Edition is sharding. Today we support only manual sharding, in the future, we will support automatic sharding (it's on our roadmap since ages ago) - There will be no drastic price increase for those who do decide to upgrade to the Enterprise edition. Correct. Best Regards, Luca Garulli VP OrientDB <http://orientdb.com/> On 23 September 2017 at 01:55, Hristo Stoyanov wrote: > Thanks Luca, > It's best to put out a blog or news announcement that clearly states that: > - All OrientDB features currently available in the Community edition will > stay there. > - There will be no drastic price increase for those who do decide to > upgrade to the Enterprise edition. > > Please, forgive the community for asking such questions, we have been > burned before. > > > On Friday, September 22, 2017 at 4:21:51 PM UTC-7, l.garulli wrote: >> >> Hi all, >> >> OrientDB is here to stay. CallidusCloud bought OrientDB as an investment >> in the Graph and Multi-Model technology because they believe this is the >> best technology in the DBMS world. >> >> In the last months, we've seen the closing of some of the DBMS companies >> that weren't able to be sustainable after years (Basho, RethinkDB, etc). >> I'm sure it has been a pain for their clients that have seen their >> investments failing and a migration to another DBMS is a very expensive >> thing. >> >> Until the last week, OrientDB was a small player, but profitable, in the >> crowded DBMS market. Thanks to CallidusCloud (a public company on NASDAQ), >> OrientDB is now the most solid company in the NoSQL space. >> >> So this is a good news for both clients and users! >> >> OrientDB Community Enterprise *remains Open Source with the same Apache >> 2 license*. OrientDB Enterprise Edition remains commercial. *All the >> clients continue to be supported*. >> >> I hope this responded to your concerns. >> >> Best Regards, >> >> Luca Garulli >> VP OrientDB >> >> >> On 22 September 2017 at 21:58, Tielman Van Vleck wrote: >> >>> True, but Oracle understands databases. Luca (we met in Austin last >>> year): you will have to fight hard for autonomy and constantly prove the >>> relevance of OrientDB within a company with other priorities. Remember what >>> happened to CompuServe after H&R Block bought them - Block intended to keep >>> the product alive, but really bought them for their computing hardware and >>> wouldn't give them the capital needed to compete against AOL's marketing. >>> Oops... don't let CC forget that story! >>> >>> -Tielman >>> >>> >>> On Friday, September 22, 2017 at 1:24:37 PM UTC-4, ad...@cs.miami.edu >>> wrote: >>>> >>>> >>We all remember the path mysql took, after oracle acquired it. >>>> >>>> I am not a heavy mysql user, but I don't think mysql took a terrible >>>> turn after oracle. Mysql still seems to be aviable when I want to install >>>> it, there is still a large communit support network, and it more less works >>>> as expected, but perhaps those who are more invested in mysql will view the >>>> situation different. >>>> >>>> -Adam >>>> >>>> On Friday, September 22, 2017 at 9:42:49 AM UTC-4, Manabu Tokunaga >>>> wrote: >>>>> >>>>> Interesting discussions. I have been in many situations where "I've >>>>> been acquired. Everything discussed here is a very legitimate customer >>>>> concern and hope that there will be official and confirmed answers from >>>>> the >>>>> new company. >>>>> >>>>> In terms of the community aspect of it, we know, for example, there >>>>> are OpenJDK vs Oracle Java and MariaDB vs mySQL type situations where they >>>>> are functionally compatible forks derived from the acquired base. If this >>>>> is possible, then as a community, we have protection. >>>>> >>>> -- >>> >>> --- >>> 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-databa...@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. > -- --- 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.
Re: [orientdb] Re: Low Performance Creating EDGE
Yes, if you can use Java with plocal connection (avoiding tcp/ip) it would
be much faster.
Best Regards,
Luca Garulli
VP OrientDB <http://orientdb.com/>
On 2 October 2017 at 12:10, Maxim Nikolaev wrote:
> Thank you! After implementing your recomendation now script creates 450 +
> Edges per sec.
>
> May be another API ( JAVA or Gremlin ) will be faster than python pyorient
> ? What about threading ?
>
> понедельник, 2 октября 2017 г., 1:18:34 UTC+3 пользователь Maxim Nikolaev
> написал:
>
>> Have two classes:
>> Person
>> Address.
>> I want create Edge where Person.AddressId = Address,Id
>> Person - 20 million Vertex
>> Address - 40 million Vertex
>>
>> Person have sub-classes as people, phone and another
>>
>> Code :
>>
>> allrecord = client.command("select count(*) from Person")
>> for i in range(0,count-1):
>> start_v = ''
>> result_v = ''
>> start_v = '#731:' + str(i)
>> Start_SysId_object = client.command("select AddressId from Person where
>> @rid=%s" % start_v)
>> try:
>> Start_SysId_object_str =
>> str(Start_SysId_object[0].oRecordData['AddressSysId'])
>> except:
>> continue
>> if Start_SysId_object_str != '':
>> Found_objects = client.command("select @rid from Address_Larix where
>> SysId=%s" % Start_SysId_object_str)
>> else:
>> continue
>> res_len = len(Found_objects)
>> if (res_len >= 1):
>> for j in range(res_len):
>> result_v = str(Found_objects[j].oRecordData['rid'])
>> z = client.command("create EDGE LiveIn FROM %s TO %s " %
>> (start_v, result_v))
>> else:
>>
>> It work very slowly , 1 -2 edge per second.
>>
>> Also I try create Link , but it creating 2 days and not success.
>>
>>
>> How to fast create EDGE ?
>>
>> --
>
> ---
> 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.
Re: [orientdb] Re: [Breaking News] CallidusCloud Acquires OrientDB, the Leading Multi-Model Database Technology
Hi all, OrientDB is here to stay. CallidusCloud bought OrientDB as an investment in the Graph and Multi-Model technology because they believe this is the best technology in the DBMS world. In the last months, we've seen the closing of some of the DBMS companies that weren't able to be sustainable after years (Basho, RethinkDB, etc). I'm sure it has been a pain for their clients that have seen their investments failing and a migration to another DBMS is a very expensive thing. Until the last week, OrientDB was a small player, but profitable, in the crowded DBMS market. Thanks to CallidusCloud (a public company on NASDAQ), OrientDB is now the most solid company in the NoSQL space. So this is a good news for both clients and users! OrientDB Community Enterprise *remains Open Source with the same Apache 2 license*. OrientDB Enterprise Edition remains commercial. *All the clients continue to be supported*. I hope this responded to your concerns. Best Regards, Luca Garulli VP OrientDB On 22 September 2017 at 21:58, Tielman Van Vleck wrote: > True, but Oracle understands databases. Luca (we met in Austin last year): > you will have to fight hard for autonomy and constantly prove the relevance > of OrientDB within a company with other priorities. Remember what happened > to CompuServe after H&R Block bought them - Block intended to keep the > product alive, but really bought them for their computing hardware and > wouldn't give them the capital needed to compete against AOL's marketing. > Oops... don't let CC forget that story! > > -Tielman > > > On Friday, September 22, 2017 at 1:24:37 PM UTC-4, ad...@cs.miami.edu > wrote: >> >> >>We all remember the path mysql took, after oracle acquired it. >> >> I am not a heavy mysql user, but I don't think mysql took a terrible turn >> after oracle. Mysql still seems to be aviable when I want to install it, >> there is still a large communit support network, and it more less works as >> expected, but perhaps those who are more invested in mysql will view the >> situation different. >> >> -Adam >> >> On Friday, September 22, 2017 at 9:42:49 AM UTC-4, Manabu Tokunaga wrote: >>> >>> Interesting discussions. I have been in many situations where "I've been >>> acquired. Everything discussed here is a very legitimate customer concern >>> and hope that there will be official and confirmed answers from the new >>> company. >>> >>> In terms of the community aspect of it, we know, for example, there are >>> OpenJDK vs Oracle Java and MariaDB vs mySQL type situations where they are >>> functionally compatible forks derived from the acquired base. If this is >>> possible, then as a community, we have protection. >>> >> -- > > --- > 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.
[orientdb] [Breaking News] CallidusCloud Acquires OrientDB, the Leading Multi-Model Database Technology
Hi guys, I'd like to share this amazing news with the community: http://orientdb.com/calliduscloud-acquires-orientdb-the-leading-multi-model-database-technology/ Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> -- --- 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.
Re: [orientdb] Nashorn JS Driver/wrapper
Hi Adam,
I think this is very interesting, especially for our JS Functions. Would
you like to contribute with a PR?
By the way, have you found a way to protect the user to call things like
System.exit()?
Best Regards,
Luca Garulli
Founder & CEO
OrientDB LTD <http://orientdb.com/>
On 12 September 2017 at 03:12, wrote:
> Hi,
>
> My day job is mostly server-side JS using Nashorn.
>
> I noticed that there are native wrappers for groovy/scala but there does
> not seem to be a native wrapper for Nashorn, So, I started working on one
> for my own purposes. Do you think this is something the larger community
> would be interested in?
>
> The goal is a light JS/Nashorn wrapper with a streamlined API suitable for
> scripting environments and server-side script. No extra jars are
> necessary, just include a single JS script the top of your nashorn file.
> Here is an example script:
>
> load("OrientDB_Doc.js");
> odb = new ODB();
>
> // opens a DB pool
> odb.openDB("plocal:/orientDB/databases/myTest", "admin", "admin");
> odb.execute("insert into Person (name, age) VALUES ('George Washington',
> 67)");
>
> // returns native JS code
> r = odb.select("select * from Person");
> r.forEach(function (obj) {
> println(obj.name + " " + obj.age);
> });
> odb.closePool();
>
>
> The benefit of using a script like this is the user does not need to worry
> themselves with the complicated Types that OrientDB has (IMHO). And the
> functions (by default, but optionally) return native JS objects instead of
> ODocuments, which is eaiser to deal with in Nashorn.
>
> The Doc API is almost done, and later I can make the graph API. Let me
> know if this is something that the community might want... or perhaps it is
> already done I just did not see it.
>
> Best,
>
> -Adam
>
> --
>
> ---
> 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.
Re: [orientdb] Restore backup created from a different instance
If they are in HA, you don't need this backup/restore procedure, right? Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> On 31 August 2017 at 23:31, AnSDE007 wrote: > At the moment, they are independent. But the team might decide to put > them in HA in the future. > > On Thursday, August 31, 2017 at 6:36:50 AM UTC-7, l.garulli wrote: >> >> Hi, >> >> Are the 2 servers in HA or are independent? >> >> Best Regards, >> >> Luca Garulli >> Founder & CEO >> OrientDB LTD <http://orientdb.com/> >> >> On 30 August 2017 at 23:25, AnSDE007 wrote: >> >>> Enrico, >>> >>> That worked and thank you very much. >>> >>> Is this a typical process to backup/restore for DR? If not, would you >>> mind sharing how most people setup their backup/restore for DR? >>> >>> Thanks. >>> >>> >>> On Wednesday, August 30, 2017 at 12:27:16 PM UTC-7, Enrico Risa wrote: >>>> >>>> Hi >>>> >>>> the metadata of the backups are stored inside the OSystem database. >>>> >>>> In order to restore the same situation of backups you should also copy >>>> >>>> 1) The file $ORIENTDB_HOME/config/backups.json >>>> 2) The OSystem database >>>> >>>> >>>> >>>> 2017-08-30 18:49 GMT+02:00 AnSDE007 : >>>> >>>>> Luca, >>>>> >>>>> Thank you for your quick response. Any guidance on how to accomplish >>>>> storing non-blocking backups (*.ibu files) on a different instance would >>>>> be >>>>> greatly appreciated. >>>>> >>>>> Thanks. >>>>> >>>>> On Wednesday, August 30, 2017 at 9:41:49 AM UTC-7, l.garulli wrote: >>>>>> >>>>>> Hi, >>>>>> >>>>>> AFAIK in OrientDB Studio, Enterprise Restore feature, reads some >>>>>> metadata, this could explain why just copying the files won't work. >>>>>> >>>>>> @Enrico, WDYT? >>>>>> >>>>>> Best Regards, >>>>>> >>>>>> Luca Garulli >>>>>> Founder & CEO >>>>>> OrientDB LTD <http://orientdb.com/> >>>>>> >>>>>> On 30 August 2017 at 17:25, AnSDE007 wrote: >>>>>> >>>>>>> I am new to OrientDB. >>>>>>> >>>>>>> We are evaluating an open source master patient index application >>>>>>> which uses embedded Enterprise OrientDB 2.2.17. One of the DR (Disaster >>>>>>> Recovery) requirements is to be able to restore the backup on a >>>>>>> different >>>>>>> server/instance. Below are the steps that I have taken and so far I >>>>>>> have >>>>>>> not been able to get this working. >>>>>>> >>>>>>> 1. On server 1, schedule a non-blocking backup in Full+Incremental >>>>>>> mode in Studio Management >>>>>>> 2. On server 1, wait until *full.ibu and *.ibu are created. In >>>>>>> Production, there will be a script that copy these files to a file >>>>>>> system >>>>>>> on a different file server every night. >>>>>>> 3. On server 2, copy those *.ibu and *full.ibu files from step #2 >>>>>>> 4. On server 2, launch Studio Management and attempt to access and >>>>>>> restore the backups >>>>>>> >>>>>>> The issue I am having is that the Studio Management on server 2 does >>>>>>> not appear to recognize the *full.ibu and the *.ibu files. Hence, I am >>>>>>> unable to restore the database on server 2. >>>>>>> >>>>>>> Am I missing any key steps here? Is there a different approach to >>>>>>> accomplish this? >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> >>>>>>> --- >>>>>>> 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-databa...@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-databa...@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-databa...@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. > -- --- 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.
Re: [orientdb] Restore backup created from a different instance
Hi, Are the 2 servers in HA or are independent? Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> On 30 August 2017 at 23:25, AnSDE007 wrote: > Enrico, > > That worked and thank you very much. > > Is this a typical process to backup/restore for DR? If not, would you > mind sharing how most people setup their backup/restore for DR? > > Thanks. > > > On Wednesday, August 30, 2017 at 12:27:16 PM UTC-7, Enrico Risa wrote: >> >> Hi >> >> the metadata of the backups are stored inside the OSystem database. >> >> In order to restore the same situation of backups you should also copy >> >> 1) The file $ORIENTDB_HOME/config/backups.json >> 2) The OSystem database >> >> >> >> 2017-08-30 18:49 GMT+02:00 AnSDE007 : >> >>> Luca, >>> >>> Thank you for your quick response. Any guidance on how to accomplish >>> storing non-blocking backups (*.ibu files) on a different instance would be >>> greatly appreciated. >>> >>> Thanks. >>> >>> On Wednesday, August 30, 2017 at 9:41:49 AM UTC-7, l.garulli wrote: >>>> >>>> Hi, >>>> >>>> AFAIK in OrientDB Studio, Enterprise Restore feature, reads some >>>> metadata, this could explain why just copying the files won't work. >>>> >>>> @Enrico, WDYT? >>>> >>>> Best Regards, >>>> >>>> Luca Garulli >>>> Founder & CEO >>>> OrientDB LTD <http://orientdb.com/> >>>> >>>> On 30 August 2017 at 17:25, AnSDE007 wrote: >>>> >>>>> I am new to OrientDB. >>>>> >>>>> We are evaluating an open source master patient index application >>>>> which uses embedded Enterprise OrientDB 2.2.17. One of the DR (Disaster >>>>> Recovery) requirements is to be able to restore the backup on a different >>>>> server/instance. Below are the steps that I have taken and so far I have >>>>> not been able to get this working. >>>>> >>>>> 1. On server 1, schedule a non-blocking backup in Full+Incremental >>>>> mode in Studio Management >>>>> 2. On server 1, wait until *full.ibu and *.ibu are created. In >>>>> Production, there will be a script that copy these files to a file system >>>>> on a different file server every night. >>>>> 3. On server 2, copy those *.ibu and *full.ibu files from step #2 >>>>> 4. On server 2, launch Studio Management and attempt to access and >>>>> restore the backups >>>>> >>>>> The issue I am having is that the Studio Management on server 2 does >>>>> not appear to recognize the *full.ibu and the *.ibu files. Hence, I am >>>>> unable to restore the database on server 2. >>>>> >>>>> Am I missing any key steps here? Is there a different approach to >>>>> accomplish this? >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> >>>>> --- >>>>> 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-databa...@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-databa...@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. > -- --- 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.
Re: [orientdb] Restore backup created from a different instance
Hi, AFAIK in OrientDB Studio, Enterprise Restore feature, reads some metadata, this could explain why just copying the files won't work. @Enrico, WDYT? Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> On 30 August 2017 at 17:25, AnSDE007 wrote: > I am new to OrientDB. > > We are evaluating an open source master patient index application which > uses embedded Enterprise OrientDB 2.2.17. One of the DR (Disaster > Recovery) requirements is to be able to restore the backup on a different > server/instance. Below are the steps that I have taken and so far I have > not been able to get this working. > > 1. On server 1, schedule a non-blocking backup in Full+Incremental mode in > Studio Management > 2. On server 1, wait until *full.ibu and *.ibu are created. In > Production, there will be a script that copy these files to a file system > on a different file server every night. > 3. On server 2, copy those *.ibu and *full.ibu files from step #2 > 4. On server 2, launch Studio Management and attempt to access and restore > the backups > > The issue I am having is that the Studio Management on server 2 does not > appear to recognize the *full.ibu and the *.ibu files. Hence, I am unable > to restore the database on server 2. > > Am I missing any key steps here? Is there a different approach to > accomplish this? > > > > > > > > > -- > > --- > 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.
Re: [orientdb] why so much hate for orientDB
Hi Adam, Thanks for opening this topic :-) Most of the leaks, rants, etc. come from the same "anonymous" source. Of course we know who's behind that: he supposed to collaborate with the OrientDB team long time ago, but then we had a divergence of opinions and that was the best way he thought he could has his revenge... There is a lot of *passion* behind Technology, Open Source, Communities. *Passion can be good and bad*. OrientDB is not the big corporation to hate. We're a small team, 99% of the people are developers, that enjoyed working to the revolutionary idea of the Multi-Model database with a Native Graph Database engine. In 2010 most of the people thought we were crazy: providing SQL to a NoSQL database, mixing all models in one. But now everybody is following our vision and MongoDB and DataStax (Cassandra) already announced to be multi-model. So we were visionary long time ago. That's said, we knew that OrientDB wasn't the most stable DBMS around. We preferred playing with the Multi-Model concept instead of making our DBMS rock solid and then having hard time to upgrade that concept. This was fundamental to quickly build up this Multi-Model idea and experiment with it. We thought that stability would come later, as soon as the model would be final. And we were right. Even if we still have users that are running OrientDB v0.9.8 inproduction, It's only with OrientDB 2.2.x that we reached the maturity and stability demanded by our users and clients. Now, we still have users that are not happy with OrientDB. The biggest mistake we see our users doing is using OrientDB as a RDBMS. We've seen so many users trying to do JOINs with OrientDB. Of course it works, but it's the worst way to use a Native Graph Database. Unfortunately most of these users ask for help one week before going in production and at that point it's impossible to help them without a complete redesign of their model. But we see also users using OrientDB at the best, without asking one single question on Stackoverflow. *Is OrientDB perfect? Of course not*. There is still a lot of work to do. We're working hard to make our DBMS unbreakable, especially in distributed configuration. We already decreased the number of bugs far below the average of other Open Source DBMSs. We've simplified the API in v3.0 (still in beta), we largely increased the number of test cases, we hired QA engineers to find issues before users do and much more. Today we have many of the Fortune500 companies in production with OrientDB, with so different use cases. This is the beauty of the Multi-Model, you can do so many things with it. Last point, not strictly technical, is *how we run the business around OrientDB*. We decided to bootstrap without getting any money from VCs. Our investors are our clients. We believe this is the right model for a software company with a product that must last for years or decades. I've seen NoSQL companies funded with tons of million of dollars not being able to reach the profitability even after many years (MongoDB, Neo4j, etc). Some of these are already failed (RethinkDB, Basho, etc.). I know that VCs can put a lot of pressure when you can't make a profit after many years. We aren't in this position and we can take all the choices we believe are good for the product, not just to make the VC happy until the next round of funding... I think this is the main reason why some of our competitors behave *unfairly* with us by feeding the "anonymous" source mentioned above. Of course there are also real users that aren't happy with OrientDB for a lot of reasons. Even if a Multi-Model can be a good fit for most of the use cases, maybe it didn't work out for them for multiple reasons. We love constructive feedback, because everytime we are able to understand what didn't work out for a user, we can work to make OrientDB a better product. Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> On 26 August 2017 at 22:30, wrote: > There seems to be lots of hates towards OrientDB on the web: leaks, rants, > etc, etc. There seems to be more of this for OrientDB than other DBs (even > the often hated MySQL). Why do you think that is? Do you think there is > merit in the hate or do you think it is mostly people using the database > incorrectly (for example not understanding how the JVM works and then > thowing one's hands in the error when they get a heap error). > > Best, > > -Adam > > -- > > --- > 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 thi
Re: [orientdb] question regarding synchronisation with version 2.2.25 on adding a new machine in a cluster
Hi Zeeshan,
Please try v2.2.26 where we fixed many of these problems. Please let me
know.
Best Regards,
Luca Garulli
Founder & CEO
OrientDB LTD <http://orientdb.com/>
On 14 August 2017 at 13:15, Zeeshan Ahmad wrote:
> Hey,
>
> I had two running master nodes i had to add another master node. My
> distributed config:
>
> {
> "replication": true,
> "hotAlignment" : false,
> "autoDeploy": true,
> "readQuorum": 1,
> "writeQuorum": "majority",
> "executionMode": "synchronous",
> "readYourWrites": true,
> "newNodeStrategy": "dynamic",
> "servers": {
> "orientdbMaster1": "master",
> "orientdbMaster2": "master",
> "orientdbMaster3": "master"
> },
> "clusters": {
> "internal": {
> },
> "*": {
> "servers": [""]
> }
> }
> }
>
>
> 2017-08-14 10:44:44:254 WARNI [orientdbMaster1] Timeout (20001ms) on
> waiting for synchronous responses from nodes=[orientdbMaster2,
> orientdbMaster3] responsesSoFar=[orientdbMaster3] request=(id=1.263
> task=gossip timestamp: 1502707464247 lockManagerServer: orientdbMaster1)
> [ODistributedDatabaseImpl]
>
> As soon the new machine joined the cluster following chain of events
> happened:
>
> 1. Added orientdbMaster3
> 2. orientdbMaster3 started synchronising the database with orientdbMaster2
> 3. During this time orientdbMaster2 became unreachable for
> orientdbMaster1. Got this in the log continuously
>
> WARNI [orientdbMaster1] Timeout (20001ms) on waiting for synchronous
> responses from nodes=[orientdbMaster2, orientdbMaster3]
> responsesSoFar=[orientdbMaster3]
> request=(id=1.263 task=gossip timestamp: 1502707464247 lockManagerServer:
> orientdbMaster1) [ODistributedDatabaseImpl]
>
> 4. Writes were not possible as the quorum of 2 was not reached. All the
> writes failed.
> 5. After the orientdbMaster3 was up, orientdbMaster2 started to rebuild
> the indexes. (Took a lot of time)
>
>
> This caused a huge down time.
>
> The same issues happens whenever a node which was the lock Manager was
> restarted. The machine starts to get the entire database.
>
> Questions:
>
> 1. Why is the entire database needed to be fetched again on every restart
> of the lockManger node?
> 2. How is the new lock Manager elected in the beginning and what is the
> process of re-election?
> 3. Can i specify the new node to get the database from a specific node?
> 4. Why are writes not possible on the node which is helping re-sync of
> database?
> 5. Why the indices rebuild whenever there is re-sync?
>
> I have waste a lot of time when i added a new machine and this caused a
> huge downtime as well.
>
>
> Thanks,
> Zeeshan
>
> --
>
> ---
> 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.
[orientdb] [Release] OrientDB 2.2.25 is out!
2.2.25 - August 02, 2017 <https://github.com/orientechnologies/orientdb/wiki/OrientDB-2.2-Release-Notes#functionality-added-or-changed>Functionality Added or Changed <https://github.com/orientechnologies/orientdb/wiki/OrientDB-2.2-Release-Notes#studio> Studio - A new 'Neo4j to OrientDB Importer' plugin that connects to Neo4j via the Neo4j remote bolt protocol has now been integrated into both OrientDB Community and Enterprise Editions. This is in addition to the already existing command-line 'Neo4j to OrientDB Importer" tool, that made use of embedded connections via the Java API (and that is still available as an external package) - Issue #432 <https://github.com/orientechnologies/orientdb-studio/issues/432> <https://github.com/orientechnologies/orientdb/wiki/OrientDB-2.2-Release-Notes#distributed> Distributed - Improved java client reconnection when Data Centers are used: two new values for the -Dnetwork.retry.strategy option have now been added: same-dc and auto- Issue #7509 <https://github.com/orientechnologies/orientdb/issues/7509#issuecomment-318439127> - Documentation <http://orientdb.com/docs/2.2.x/Data-Centers.html#client-reconnection> <https://github.com/orientechnologies/orientdb/wiki/OrientDB-2.2-Release-Notes#etl> ETL - Added support for algorithm parameter in index creation - Issue #7581 <https://github.com/orientechnologies/orientdb/issues/7581> <https://github.com/orientechnologies/orientdb/wiki/OrientDB-2.2-Release-Notes#bugs-fixed>Bugs Fixed <https://github.com/orientechnologies/orientdb/wiki/OrientDB-2.2-Release-Notes#core> Core - Fixed Bug on JSON import in multithreading environment - Internal Issue #9020 - Fixed bug with database backup/restoration and cache state file, cache state file is now ignored - Issue #7601 <https://github.com/orientechnologies/orientdb/issues/7601> & Internal Issue #9024 - Improved performance of rid bag compare - Internal Issue #8803 <https://github.com/orientechnologies/orientdb/wiki/OrientDB-2.2-Release-Notes#sql> SQL - Fixed query parsing issue when "in" clause occurs after "or" condition with parentheses - Issue #6834 <https://github.com/orientechnologies/orientdb/issues/6834> - Fixed exception in select from collection of DATETIME or DATE, using prepared statement - Issue #7574 <https://github.com/orientechnologies/orientdb/issues/7574> - Fixed comparison of Short values with IN and CONTAINS in SQL - Issue #7578 <https://github.com/orientechnologies/orientdb/issues/7578> - Fixed StackOverflow exception when a list of enums is passed as an SQL param - Issue #7418 <https://github.com/orientechnologies/orientdb/issues/7418> - Fixed usage of include function in Match statement - Issue #271 <https://github.com/orientechnologies/orientjs/issues/271> - Fixed security checks in SQL to allow reading of own OUser record - Issue #7549 <https://github.com/orientechnologies/orientdb/issues/7549> <https://github.com/orientechnologies/orientdb/wiki/OrientDB-2.2-Release-Notes#server> Server - Implemented GZip Compression for static resources - Issue #476 <https://github.com/orientechnologies/orientdb-studio/issues/476> <https://github.com/orientechnologies/orientdb/wiki/OrientDB-2.2-Release-Notes#distributed-1> Distributed - When executing the HA SYNC CLUSTER command, part of the cluster was not migrated. Now fixed - Internal Issue #8982 - Warning: HA SYNC CLUSTER will now trigger an automatic rebuild of the indices defined on the Class the cluster belongs to. Depending on the number of defined indices and amount of data included in the Class this operation can take some time. Furthermore it is important to wait that the sync cluster operation has finished before performing any database operations that involve that cluster. - Fixed issue related to local DC quorum management - Issue #7539 <https://github.com/orientechnologies/orientdb/issues/7539> & Internal Issue #8981 - Enlarged default timeout for database chunk deployment - Internal Issue #8923 - Fixed issue that was causing record version to be different on different nodes - Internal Issue #9003 - Fixed issue with distributed sequences <https://github.com/orientechnologies/orientdb/wiki/OrientDB-2.2-Release-Notes#lucene-spatial>Lucene Spatial - Fixed lifecycle on the legacy spatial index - Issue #7585 <https://github.com/orientechnologies/orientdb/issues/7585> <https://github.com/orientechnologies/orientdb/wiki/OrientDB-2.2-Release-Notes#console> Console - Fixed retrieval of custom conflict strategy from remote - Internal Issue #8931 Download it from http://orientdb.com/download/. Best Regards,
[orientdb] Get notified on new OrientDB releases
Hi guys, Maybe not everybody knows that you can get notified about new OrientDB releases by subscribing to this feed: OrientDB Release Feed <https://github.com/orientechnologies/orientdb/releases.atom>. Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> -- --- 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.
Re: [orientdb] Re: Inconsistent versions in distributed setup
Hi Zeeshan, First of all, please upgrade to the latest 2.2.x that is 2.2.23 right now. We fixed some synchronization issues. Then, did you check that on 2 servers the version wasn't the same? Try this query "select from #25:426820" on both servers. Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> On 20 July 2017 at 10:18, Zeeshan Ahmad wrote: > can anyone help on this? If there is no solution to this, we will have to > drop the plan of using ODB in production. > > >> -- > > --- > 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.
[orientdb] GraphQL for OrientDB is finally available
Hi guys, Have you ever dreamed about using *GraphQL* with OrientDB? Well, *Predrag* (Kensho company) just published a plugin that complies GraphQL statements in OrientDB SQL: https://blog.kensho.com/compiled-graphql-as-a-database-query-language-72e106844282 Best Regards, Super cool. Congrats Predrag for this well-done plugin! Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> <http://orientdb.com/> -- --- 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.
Re: [orientdb] Gremlin 3 support
Hi, Look at: http://orientdb.com/orientdb-officially-supports-tinkerpop-3/ Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> On 18 July 2017 at 17:52, Padmaraj Madatha wrote: > Is there any plan to upgrade OrientDB to support gremlin 3? > > -- > > --- > 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.
Re: [orientdb] Distributed OrientDB via Multi-host Docker
Hi Stefan,
If you want to use OrientDB in a clustered configuration with Docker, you
could leverage on Kubernates.
For Kubernates we have a working configuration. Rename the attached file as
hazelcast.xml and put in the config directory overwriting the default one.
Then you need this extra jar:
com.hazelcast
hazelcast-kubernetes
${hazelcast-kubernetes-version}
For more information look at https://github.com/hazelcast/hazelcast
-kubernetes.
I hope this help. Please let me know how is going.
About Docker, use the official one: https://hub.docker.com/_/orientdb/.
Best Regards,
Luca Garulli
Founder & CEO
OrientDB LTD <http://orientdb.com/>
On 6 July 2017 at 10:54, Stefan Bergh wrote:
> Hi,
> I know this thread is long dead, but I am trying to do this exact same
> thing. I was able to access the repo https://github.com/abcum/
> docker-orientdb.git about a week ago, but it is now 404-ing. Is that
> code gone for good, or is there any way I could grab it from somewhere?
>
> Thanks in advance,
> Stefan Bergh
>
> On Wednesday, March 4, 2015 at 7:41:02 AM UTC-6, Tobie Morgan Hitchcock
> wrote:
>>
>> Hi Esen,
>>
>> I've just been through the same problem, but have a solution.
>>
>> Basically, Hazelcast attaches itself to the private ip address of the
>> docker container, and notifies other nodes of this ip address (meaning that
>> it does not ever match the members). There are two solutions...
>>
>> 1. Use *docker run --net=host* to run the docker container (works ok,
>> but the container is therefore not running in it's separate network).
>> 2. Pass the private/public IP address of the machine to the docker
>> container so that Hazelcast knows which IP address to bind to.
>>
>>1. Add >>IPV4ADDRESSHERE into hazelcast.xml
>>2. Add IPV4ADDRESSHERE>etwork>
>>
>> I've setup a docker container to do exactly this, which can be used to
>> setup a distributed OrientDB running on CoreOS using Fleet (fleetctl). This
>> will work on Vagrant or Amazon EC2/VPC.
>>
>> The repository is available here: https://github.com/abcum
>> /docker-orientdb.git
>>
>> Tobie
>>
>>
>> On Tuesday, 6 January 2015 07:19:42 UTC, Esen Sagynov wrote:
>>>
>>> I can successfully telnet to each server from any other server because
>>> incoming requests are allowed. In fact, each server successfully receives a
>>> connection request, however, there seems to be some kind of a validation.
>>> When the host A receives a connection request from host B, host A checks if
>>> the requested IP address is host A's IP address. Now here this validation
>>> fails according to the above error message.
>>>
>>> I wonder if it is necessary to do such validations in ODB?
>>>
>>> On Monday, January 5, 2015 9:27:31 PM UTC+9, Lvc@ wrote:
>>>>
>>>> Hi Esen,
>>>> Seems OrientDB servers can't see each other. I suggest you to try if
>>>> connections are allowed between hosts with CURL.
>>>>
>>>> Lvc@
>>>>
>>>>
>>>> On 5 January 2015 at 07:19, Esen Sagynov wrote:
>>>>
>>>>> Using ODB 2.0-SNAPSHOT (Jan 5, 2015).
>>>>>
>>>>> My nodes in Docker containers on separate physical machines cannot
>>>>> join to each other. The establish a connection however eventually they
>>>>> refuse joining because some conditions aren't met.
>>>>>
>>>>> The following are logs on Host 2:
>>>>>
>>>>> 2015-01-05 06:07:15:691 INFO [172.17.0.3]:2434 [orientdb] [3.3]
>>>>> Accepting socket connection from /123.123.123.124:55647 [
>>>>> SocketAcceptor]
>>>>> 2015-01-05 06:07:15:692 INFO [172.17.0.3]:2434 [orientdb] [3.3]
>>>>> Established socket connection between /172.17.0.3:2434 and /123.123.
>>>>> 123.124:55647 [TcpIpConnectionManager]
>>>>> 2015-01-05 06:07:15:694 WARNING [172.17.0.3]:2434 [orientdb] [3.3]
>>>>> Wrong bind request from Address[172.17.0.12]:2434! This node is not
>>>>> requested endpoint: Address[123.123.123.124]:2434 [
>>>>> TcpIpConnectionManager]
>>>>>
>>>>> Host 1 (123.123.123.123) running ODB in a container 172.17.0.3:2434.
>>>>> Host 2 (123.123.123.124) running ODB in a container 172.17.0.12:2434.
>>>>> Host 3 (123.123.123.125) running ODB in a container 172.17.0.10:2434.
>>>>>
>>>>> Because docker on each
[orientdb] How Graph Databases Solve Big Data Complexity, San Francisco, FREE event, join us!
Hi Guys, I will present "How Graph Databases Solve Big Data Complexity" in San Francisco, on July 13 at 6:00 pm - 7:30 pm. It's a FREE event: http://orientdb.com/event/how-graph-databases-solve-big-data-complexity/ I'd be super happy to meet more OrientDB users. If you're in the Valley mid-July, don't miss it! Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> -- --- 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.
Re: [orientdb] OrientDB vs Cassandra Comparision
Hi LP, On 26 June 2017 at 22:14, wrote: > Hi, > > We are evaluating NoSQL datastore for our project. We have short listed > few among which Cassandra and OrientDB are one of the candidates. Our key > requirements are... > > 1> Very low single read and write latency (< 5 ms) > This is as lookup by primary key? > 2> Very low NON-KEY single read and write latency (< 5 ms). In Cassandra > we are allowed to denormalize and store data in multiple tables. > What do you mean? Any query with filtering on secondary indexes? > 3> Data size in each table - 50,000M rows > Do you mean 50 Billion rows per table? How many tables? > 4> Auto sharding/rebalancing > OrientDB doesn't have auto-sharding (yet), so it's up to you to partitionate the records (usually based on hashing a key): the sharding is only manual. > 5> Multi-data center replication support > Only in the Enterprise Edition. > 6> Product should be very very stable > To be honest, as distributed database, Cassandra is more mature. OrientDB, instead, is much more mature as Graph Database (in comparison to DataStax DSE Graph) and much faster (see below). > 7> Should be Apache 2 Licensed where ALL the above key features are > available in the FREE/Community edition. > Multiple Data-Center is Enterprise only, all the rest is in Community Edition (=Apache2) > Can anyone help with little details around these criteria. Any pointer to > benchmark data of both done together would also help. > This is the result of Yahoo benchmark: [image: Inline images 1] OrientDB is from 200% to 300% faster in all the workloads. *This is not a benchmark we created from scratch to win*, but it's the famous: https://github.com/brianfrankcooper/YCSB/wiki Running OrientDB and Cassandra distributed. Same hw and sw configuration, of course. > Regards, > LP > > Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> -- --- 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.
Re: [orientdb] Indices and Memory Usage
Hi John, At OrientDB startup, haven't you seen a warning in the log about this missing setting? Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> On 18 May 2017 at 09:07, Andrey Lomakin wrote: > If you want to calculate how much memory should be consumed by OrientDB > please look at com.orientechnologies.common.directmemory:type= > OByteBufferPoolMXBean JMX bean it contains such attribute as > "preAllocationLimit" which will suggest you how much direct memory now is > set to be used by the server. > > If you need to be sure that you consume not more than you intended to > provide for ODB server, please set system property " > storage.diskCache.bufferSize" to the amount of direct memory in megabytes > which you wish to allow to allocate by the server. > > To be sure that no more direct memory than intended is allocated by ODB > server. > Please run the test and after 24 hours (I suppose that is enough) please > send us values of attributes of following JMX beans: > >1. com.orientechnologies.common.directmemory:type=OByteBufferPoolMXBean >2. java.nio:type=BufferPool,name=direct > > So we can check whether ODB consumes direct memory according to > parameters which you set. > > P.S. I do not think that there will be any additional value to switch to > the server with a bigger amount of memory. I suppose would be better to set > server settings accordingly. > > > On Thu, May 18, 2017 at 9:55 AM Andrey Lomakin > wrote: > >> Hi John, >> >> I suppose you did not set -XX:MaxDirectMemorySize=512g parameter. >> >> >> On Wed, May 17, 2017 at 7:07 PM John J. Szucs >> wrote: >> >>> After 70 hours on a 32GB VM, ODB 2.2.20, JRE 8u131, the job failed with >>> a direct buffer memory exception. Given the complications I mentioned >>> above, my next step is going to be to get a high-RAM AWS EC2 instance and >>> run this there. However, as I mentioned above, my leadership is getting >>> frustrated with this situation. >>> >>> -- John >>> >>> 'Battle of banja luka'. >>> com.orientechnologies.orient.core.exception.ODatabaseException: >>> Error on retrieving record #63:19090001 (cluster: xlink_simple_2) >>> >>> DB name="kb" >>> at com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx. >>> executeReadRecord(ODatabaseDocumentTx.java:2050) >>> at com.orientechnologies.orient.core.tx.OTransactionOptimistic. >>> loadRecord(OTransactionOptimistic.java:187) >>> at com.orientechnologies.orient.core.tx.OTransactionOptimistic. >>> loadRecord(OTransactionOptimistic.java:162) >>> at com.orientechnologies.orient.core.tx.OTransactionOptimistic. >>> loadRecord(OTransactionOptimistic.java:291) >>> at com.orientechnologies.orient.core.db.document. >>> ODatabaseDocumentTx.load(ODatabaseDocumentTx.java:1729) >>> at com.orientechnologies.orient.core.db.document. >>> ODatabaseDocumentTx.load(ODatabaseDocumentTx.java:102) >>> at com.orientechnologies.orient.core.id.ORecordId.getRecord( >>> ORecordId.java:329) >>> at com.tinkerpop.blueprints.impls.orient.OrientEdgeIterator. >>> createGraphElement(OrientEdgeIterator.java:72) >>> at com.tinkerpop.blueprints.impls.orient.OrientEdgeIterator. >>> createGraphElement(OrientEdgeIterator.java:44) >>> at com.orientechnologies.orient.core.iterator. >>> OLazyWrapperIterator.hasNext(OLazyWrapperIterator.java:93) >>> at com.orientechnologies.common.collection.OMultiCollectionIterator. >>> hasNextInternal(OMultiCollectionIterator.java:97) >>> at com.orientechnologies.common.collection.OMultiCollectionIterator. >>> hasNext(OMultiCollectionIterator.java:78) >>> at com.lusidity.mind.model.Node.getLinks(Node.java:308) >>> at com.lusidity.mind.model.Node.hasLink(Node.java:435) >>> at com.lusidity.mind.etl.providers.mediawiki.BaseMediaWikiPage. >>> loadHyperlinks(BaseMediaWikiPage.java:401) >>> at com.lusidity.mind.etl.providers.mediawiki.BaseMediaWikiPage.link( >>> BaseMediaWikiPage.java:260) >>> at com.lusidity.mind.etl.providers.mediawiki.BaseMediaWikiPage.load( >>> BaseMediaWikiPage.java:240) >>> at com.lusidity.mind.etl.providers.mediawiki.BaseMediaWikiPage.process( >>> BaseMediaWikiPage.java:98) >>> at com.lusidity.mind.etl.providers.mediawiki.ArticleHandler.process( >>> ArticleHandler.java:113) >>> at com.lusidity.mind.etl.providers.mediawiki.ArticleHandler.process( >>> ArticleHandler.java:75
Re: [orientdb] Re: Run OrientDB HA from Java
Ok, if you see server.sh it has this setting:
-Djava.util.logging.config.file=$ORIENTDB_HOME/config/orientdb-server-log.properties
Could you please run your JVM with OrientDB embedded with this setting?
Best Regards,
Luca Garulli
Founder & CEO
OrientDB LTD <http://orientdb.com/>
On 2 May 2017 at 02:40, Ray Neiheiser wrote:
> Didn't change anything of the logging settings.
> The only code starting the database is the one I set up there.
>
> 2017-05-01 21:35 GMT-03:00 Luca Garulli :
>
>> Ok, what logging settings are you using? Could you please set the
>> OrientDB logging settings? Look at server.sh and copy the setting under
>> your JVM.
>>
>> Best Regards,
>>
>> Luca Garulli
>> Founder & CEO
>> OrientDB LTD <http://orientdb.com/>
>>
>> On 1 May 2017 at 23:58, Ray Neiheiser wrote:
>>
>>> Now It's completely empty.
>>>
>>> 2017-05-01 18:57 GMT-03:00 Luca Garulli :
>>>
>>>> Great, do you see any logs under the "log" folder you just mentioned?
>>>>
>>>> Best Regards,
>>>>
>>>> Luca Garulli
>>>> Founder & CEO
>>>> OrientDB LTD <http://orientdb.com/>
>>>>
>>>> On 1 May 2017 at 22:26, Ray Neiheiser wrote:
>>>>
>>>>> Didn't create any logs at all.
>>>>>
>>>>> I'm start it from java:
>>>>>
>>>>> factory = new OrientGraphFactory(BASE_PATH + this.id).setupPool(1, 10);
>>>>>
>>>>> And the BASE_PATH:
>>>>>
>>>>> "PLOCAL:" + System.getProperty("user.home") + "/OrientDB";
>>>>>
>>>>> in OrientDB/ there are the folders like config, bin, log etc.
>>>>> Additionally in OrientDB/ there are also all the database things orientDB
>>>>> generates.
>>>>>
>>>>>
>>>>> Am Montag, 1. Mai 2017 17:22:11 UTC-3 schrieb l.garulli:
>>>>>>
>>>>>> Hi Ray,
>>>>>>
>>>>>> Without the logs it's hard to guess. Could you provide logs of all
>>>>>> servers zipped?
>>>>>>
>>>>>> Best Regards,
>>>>>>
>>>>>> Luca Garulli
>>>>>> Founder & CEO
>>>>>> OrientDB LTD <http://orientdb.com/>
>>>>>>
>>>>>> On 1 May 2017 at 22:06, Ray Neiheiser wrote:
>>>>>>
>>>>>>> Would be very helpful if I could get the results of this into my
>>>>>>> academic paper
>>>>>>>
>>>>>>>
>>>>>>> Am Mittwoch, 12. April 2017 15:28:17 UTC-3 schrieb Ray Neiheiser:
>>>>>>>>
>>>>>>>> I am trying o figure out how I can run OrientDB HA from java and
>>>>>>>> then also write and read from java.
>>>>>>>>
>>>>>>>> I used the guide configuration for the ha clusters. I have all the
>>>>>>>> 4 databases replicated at the servers but if I run it they act
>>>>>>>> independently.
>>>>>>>>
>>>>>>> --
>>>>>>>
>>>>>>> ---
>>>>>>> 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-databa...@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.
>>>>>
>>>>
>>>> --
>>>>
>>>> ---
>>>> You received this message because you are subscribed to a topic in the
>>>> Google Groups "OrientDB" group.
>>>> To unsubscribe from this topic, visit https://groups.google.com/d/to
>>>> pic/orient-database/nF0SeqzwaLY/unsubscribe.
>>>> To unsubscribe from this group and all its topics, 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.
>>>
>>
>> --
>>
>> ---
>> You received this message because you are subscribed to a topic in the
>> Google Groups "OrientDB" group.
>> To unsubscribe from this topic, visit https://groups.google.com/d/to
>> pic/orient-database/nF0SeqzwaLY/unsubscribe.
>> To unsubscribe from this group and all its topics, 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.
>
--
---
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.
Re: [orientdb] Re: Run OrientDB HA from Java
Ok, what logging settings are you using? Could you please set the OrientDB
logging settings? Look at server.sh and copy the setting under your JVM.
Best Regards,
Luca Garulli
Founder & CEO
OrientDB LTD <http://orientdb.com/>
On 1 May 2017 at 23:58, Ray Neiheiser wrote:
> Now It's completely empty.
>
> 2017-05-01 18:57 GMT-03:00 Luca Garulli :
>
>> Great, do you see any logs under the "log" folder you just mentioned?
>>
>> Best Regards,
>>
>> Luca Garulli
>> Founder & CEO
>> OrientDB LTD <http://orientdb.com/>
>>
>> On 1 May 2017 at 22:26, Ray Neiheiser wrote:
>>
>>> Didn't create any logs at all.
>>>
>>> I'm start it from java:
>>>
>>> factory = new OrientGraphFactory(BASE_PATH + this.id).setupPool(1, 10);
>>>
>>> And the BASE_PATH:
>>>
>>> "PLOCAL:" + System.getProperty("user.home") + "/OrientDB";
>>>
>>> in OrientDB/ there are the folders like config, bin, log etc.
>>> Additionally in OrientDB/ there are also all the database things orientDB
>>> generates.
>>>
>>>
>>> Am Montag, 1. Mai 2017 17:22:11 UTC-3 schrieb l.garulli:
>>>>
>>>> Hi Ray,
>>>>
>>>> Without the logs it's hard to guess. Could you provide logs of all
>>>> servers zipped?
>>>>
>>>> Best Regards,
>>>>
>>>> Luca Garulli
>>>> Founder & CEO
>>>> OrientDB LTD <http://orientdb.com/>
>>>>
>>>> On 1 May 2017 at 22:06, Ray Neiheiser wrote:
>>>>
>>>>> Would be very helpful if I could get the results of this into my
>>>>> academic paper
>>>>>
>>>>>
>>>>> Am Mittwoch, 12. April 2017 15:28:17 UTC-3 schrieb Ray Neiheiser:
>>>>>>
>>>>>> I am trying o figure out how I can run OrientDB HA from java and then
>>>>>> also write and read from java.
>>>>>>
>>>>>> I used the guide configuration for the ha clusters. I have all the 4
>>>>>> databases replicated at the servers but if I run it they act
>>>>>> independently.
>>>>>>
>>>>> --
>>>>>
>>>>> ---
>>>>> 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-databa...@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.
>>>
>>
>> --
>>
>> ---
>> You received this message because you are subscribed to a topic in the
>> Google Groups "OrientDB" group.
>> To unsubscribe from this topic, visit https://groups.google.com/d/to
>> pic/orient-database/nF0SeqzwaLY/unsubscribe.
>> To unsubscribe from this group and all its topics, 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.
>
--
---
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.
Re: [orientdb] Re: Run OrientDB HA from Java
Great, do you see any logs under the "log" folder you just mentioned?
Best Regards,
Luca Garulli
Founder & CEO
OrientDB LTD <http://orientdb.com/>
On 1 May 2017 at 22:26, Ray Neiheiser wrote:
> Didn't create any logs at all.
>
> I'm start it from java:
>
> factory = new OrientGraphFactory(BASE_PATH + this.id).setupPool(1, 10);
>
> And the BASE_PATH:
>
> "PLOCAL:" + System.getProperty("user.home") + "/OrientDB";
>
> in OrientDB/ there are the folders like config, bin, log etc.
> Additionally in OrientDB/ there are also all the database things orientDB
> generates.
>
>
> Am Montag, 1. Mai 2017 17:22:11 UTC-3 schrieb l.garulli:
>>
>> Hi Ray,
>>
>> Without the logs it's hard to guess. Could you provide logs of all
>> servers zipped?
>>
>> Best Regards,
>>
>> Luca Garulli
>> Founder & CEO
>> OrientDB LTD <http://orientdb.com/>
>>
>> On 1 May 2017 at 22:06, Ray Neiheiser wrote:
>>
>>> Would be very helpful if I could get the results of this into my
>>> academic paper
>>>
>>>
>>> Am Mittwoch, 12. April 2017 15:28:17 UTC-3 schrieb Ray Neiheiser:
>>>>
>>>> I am trying o figure out how I can run OrientDB HA from java and then
>>>> also write and read from java.
>>>>
>>>> I used the guide configuration for the ha clusters. I have all the 4
>>>> databases replicated at the servers but if I run it they act independently.
>>>>
>>> --
>>>
>>> ---
>>> 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-databa...@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.
>
--
---
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.
Re: [orientdb] Re: Run OrientDB HA from Java
Hi Ray, Without the logs it's hard to guess. Could you provide logs of all servers zipped? Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> On 1 May 2017 at 22:06, Ray Neiheiser wrote: > Would be very helpful if I could get the results of this into my academic > paper > > > Am Mittwoch, 12. April 2017 15:28:17 UTC-3 schrieb Ray Neiheiser: >> >> I am trying o figure out how I can run OrientDB HA from java and then >> also write and read from java. >> >> I used the guide configuration for the ha clusters. I have all the 4 >> databases replicated at the servers but if I run it they act independently. >> > -- > > --- > 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.
Re: [orientdb] Run OrientDB HA from Java
Hi Ray, Any errors in the logs? Can you post one of server's log? Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> On 12 April 2017 at 20:28, Ray Neiheiser wrote: > I am trying o figure out how I can run OrientDB HA from java and then also > write and read from java. > > I used the guide configuration for the ha clusters. I have all the 4 > databases replicated at the servers but if I run it they act independently. > > -- > > --- > 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.
Re: [orientdb] Re: The property type of a content in schema less mode
Hi, Indexing of embedded properties is not supported yet, even if there is this PR that does it: https://github.com/orientechnologies/orientdb/pull/7093 We didn't merge in the official branch because some test cases are still missing, but you could use it. In this case, please comment the PR to see how is going. Thanks. Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> On 10 February 2017 at 16:15, Oleksandr Gubchenko wrote: > Choose from one of the embedded types: > http://orientdb.com/docs/last/Types.html > > Il giorno giovedì 9 febbraio 2017 19:39:49 UTC+1, André Toscano ha scritto: >> >> Hi everyone >> We are using OrientDB like mongodb for some properties and it is working >> very well but we need to index some keys of the document (considering >> JSON). >> Please, what is the type of a property that stores a json object with >> many levels nested? >> Thanks in advance >> Best regards >> André >> >> On 6 Jan 2017 06:24, wrote: >> >> orient-database@googlegroups.com >> <https://groups.google.com/forum/?utm_source=digest&utm_medium=email#!forum/orient-database/topics> >> Google >> Groups >> <https://groups.google.com/forum/?utm_source=digest&utm_medium=email/#!overview> >> <https://groups.google.com/forum/?utm_source=digest&utm_medium=email/#!overview> >> Topic digest >> View all topics >> <https://groups.google.com/forum/?utm_source=digest&utm_medium=email#!forum/orient-database/topics> >> >>- Proper way to generate and insert data into OrientDB >> >> <#m_8605816414272133637_CAPrw5MEiW4xEetA8hd-qYQzfgnfdWR0q61D4=-KHmaaMQ4yfyw@mail.gmail.com_m_4313801924897894530_group_thread_0> >>- 2 Updates >>- Kotlin >> >> <#m_8605816414272133637_CAPrw5MEiW4xEetA8hd-qYQzfgnfdWR0q61D4=-KHmaaMQ4yfyw@mail.gmail.com_m_4313801924897894530_group_thread_1> >>- 1 Update >>- Reached maximum number of concurrent connections >> >> <#m_8605816414272133637_CAPrw5MEiW4xEetA8hd-qYQzfgnfdWR0q61D4=-KHmaaMQ4yfyw@mail.gmail.com_m_4313801924897894530_group_thread_2> >>- 1 Update >> >> Proper way to generate and insert data into OrientDB >> <http://groups.google.com/group/orient-database/t/847440ecf0235c40?utm_source=digest&utm_medium=email> >> Cyprien Gottstein : Jan 05 06:44AM -0800 >> >> Hi, >> >> The scripts are in java, those are not batches, and we didn't wanted to >> post it online to be perfectly honest. >> >> But. >> >> Great news, problem solved ! >> >> I remembered something crucial, it's mainly me who is working on the >> subject and at first i wanted to run the OrientDB server on my own local >> machine. Since my computer is not what i would call young and powerful, i >> asked to make it run on a virtual machine in our own datacenter. I work >> in >> France. The Datacenter is in Poland. >> >> What was it again ? Non-Transactionnal Mode means " for every new entity >> we >> write it immediately on disk ", it meant for every entry we were eating >> the >> latency between our building in France and the datacenter in Poland. >> >> We made a proper uber-jar to run the generation code on the very same >> machine holding the Orient DB server's instance. >> We did some simple benchmark to check how the total execution time would >> behave depending on the transaction mode and location of the program. >> >> Job Place - Transactionnal : 900 secs (i don't have the real number, i >> just >> know its around that, sorry.) >> Job Place - Non-Transactionnal : more than 54000 secs >> Datacenter - Transactionnal : 212 secs >> Datacenter - Non-Transactionnal : 2700 secs (i don't have the real >> number, >> i just know its around that, sorry.) >> >> So thanks to executing the code from the right place we avoided some HUGE >> loss of times. The Non-Transactionnal mode is slower but your promess was >> kept, it runs with a constant amount of RAM, that means if we want to >> generate 10 millions or even 50 millions of entities we can in a >> reasonnable time so i would guess it's fine. >> >> Last question and i think this case will be closed (at least for me) : >> >> The OrientDB Documentation warns in >> http://orientdb.com/docs/last/Performance-Tuning.html#wise-u >> se-of-transactions >> that : >> >> "Transactions slow down massive inserts unless you're using a "remote" >> > conne
Re: [orientdb] Update doesn't complete without further explanations or errors
Hi Andre',
I think it's a timeout issue. You should check the default settings in your
client (console in this case). How much time does it take to complete?
Best Regards,
Luca Garulli
Founder & CEO
OrientDB LTD <http://orientdb.com/>
On 14 February 2017 at 23:15, André Toscano wrote:
> Hello everyone.
> I've got this today in my console (2.2.14 - community version):
>
> orientdb {db=mygraphdb}> update tags set rids = (select distinct(@rid)
> from Entities where metadata.tags is not null and $parent.$current.tag in
> metadata.tags)
>
> Error: com.orientechnologies.common.io.OIOException: Channel is closed
> Error: java.io.IOException: Channel is closed
>
> I've checked the memory, processors and everything is ok.
> Any hint about how to workaround with this?
> Thanks in advance.
> Best regards.
>
> André Emilio Toscano
>
> --
>
> ---
> 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.
Re: [orientdb] How to calculate OrientDB hosting cost projection?
On 8 February 2017 at 15:13, Suyog Kale wrote: > Thanks Luca, I will have look the reference you have mentioned. Do you > also recommend: > >1. Min system requirements for each node? >2. As per above sample data how much CPU, RAM, Storage need to be >allocated and how auto-scaling is recommended? > > It's hard to say without the other metrics. You only need a lot of storage, then CPU & RAM is pretty much related to how your app is developed, how you use OrientDB and the performance you require. Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> Regards, > Suyog > > On Wednesday, 8 February 2017 07:55:47 UTC+5:30, l.garulli wrote: >> >> Hi Suyog, >> >> 3 servers could be enough as storage (just buy huge space), but as far as >> we're talking about performance you should evaluate >> different kind of information, like how many users are connected at the >> same time, how many queries every user executes, etc. >> >> For example the best thing you can do with a social network use case is >> using LIVE QUERIES (http://orientdb.com/docs/2.2/Live-Query.html) to >> avoid to >> poll the servers with tons of requests to check if there are any updates. >> >> >> >> Best Regards, >> >> Luca Garulli >> Founder & CEO >> OrientDB LTD <http://orientdb.com/> >> >> On 8 February 2017 at 00:12, Suyog Kale wrote: >> >>> Hello, >>> >>> I have to create cost projection for hosting orientdb cluster with for >>> following growing data (I have considered facebook application as sample >>> data): >>> >>> >>> >>> >>> If I assume 3 nodes in orientDB cluster with replica. then >>> >>>1. what would be approx RAM, CPU & persistent storage allocation for >>>each node? >>>2. how much additional % memory/storage recommended to consider for >>>each node (ex, query processing, cache, cluster handling, fragmentation >>> etc) >>>3. what approaches recommended to define auto-scaling ? (ex. storage >>>scaling per node Or adding new node) >>> >>> Please let me know I need to consider any additional factors those will >>> drive the resource allocation and cost. >>> >>> >>> >>> -- >>> >>> --- >>> 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-databa...@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. > -- --- 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.
Re: [orientdb] How to calculate OrientDB hosting cost projection?
Hi Suyog, 3 servers could be enough as storage (just buy huge space), but as far as we're talking about performance you should evaluate different kind of information, like how many users are connected at the same time, how many queries every user executes, etc. For example the best thing you can do with a social network use case is using LIVE QUERIES (http://orientdb.com/docs/2.2/Live-Query.html) to avoid to poll the servers with tons of requests to check if there are any updates. Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> On 8 February 2017 at 00:12, Suyog Kale wrote: > Hello, > > I have to create cost projection for hosting orientdb cluster with for > following growing data (I have considered facebook application as sample > data): > > > > > If I assume 3 nodes in orientDB cluster with replica. then > >1. what would be approx RAM, CPU & persistent storage allocation for >each node? >2. how much additional % memory/storage recommended to consider for >each node (ex, query processing, cache, cluster handling, fragmentation > etc) >3. what approaches recommended to define auto-scaling ? (ex. storage >scaling per node Or adding new node) > > Please let me know I need to consider any additional factors those will > drive the resource allocation and cost. > > > > -- > > --- > 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.
Re: [orientdb] Re: Released OrientDB v2.2.16
Yes, sorry. Latest. Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> On 7 February 2017 at 00:28, odbuser wrote: > Luca, do you mean "latest" instead of "last"? > > > On Sunday, February 5, 2017 at 6:27:31 PM UTC-5, l.garulli wrote: >> >> Hi guys, >> >> This is the last OrientDB GA. >> >> Release Notes: https://github.com/orientechno >> logies/orientdb/wiki/OrientDB-2.2-Release-Notes#2216---february-02-2017 >> >> Thanks. >> Best Regards, >> >> Luca Garulli >> Founder & CEO >> OrientDB LTD <http://orientdb.com/> >> > -- > > --- > 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.
[orientdb] Released OrientDB v2.2.16
Hi guys, This is the last OrientDB GA. Release Notes: https://github.com/orientechnologies/orientdb/wiki/OrientDB-2.2-Release-Notes#2216---february-02-2017 Thanks. Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> -- --- 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.
Re: [orientdb] [Announce]: ActiveOrient 0.6
Hi Hartmut, Thank you for keeping the driver updated! @Santo, could you please update the docs? Thanks Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> On 2 February 2017 at 20:32, hartmut bischoff wrote: > > Hi folks, > today I released a new Version of ActiveOrient, Access OrientDB using ruby > aka ActiveRecord > > https://github.com/topofocus/active-orient > > The gem is now rails 5 compatible > > Luigi, can you please update the description in the language-driver > section accordingly. > > Geetings from Stuttgart > >> >> hartmut >> > -- > > --- > 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.
Re: [orientdb] Re: Training: Are you already a Black Belt with OrientDB?
You're right. The requirement of a Google Account has been removed, but the name + email remained mandatory. Now they are optional. Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> On 2 February 2017 at 21:38, odbuser wrote: > Can't say it's anonymous and have required name and email fields... of > course it could be filled out with garbage but still :0) > > If you'd like to contribute to this anonymous 1-minute survey, this is the >> link: >> > -- > > --- > 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.
[orientdb] Importer Neo4j -> OrientDB
Hi guys, Have you discovered OrientDB just a few minutes ago, but you already started developing with Neo4j? No problem, we have an importer: https://dzone.com/articles/introducing-the-neo4j-to-orientdb-importer Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> -- --- 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.
[orientdb] Training: Are you already a Black Belt with OrientDB?
Hi guys, Even if most of you are already black belt level with OrientDB, we're scheduling the new training days and we'd like to know what's your level and what kind of training could you be interested in: Java Development? DBA? Advanced Tuning? If you'd like to contribute to this anonymous 1-minute survey, this is the link: http://mkt.orientdb.com/training-survey Thanks in advance. Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> -- --- 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.
[orientdb] Keep your OrientDB Database Secure
Hi OrientDB Users, I don't know if all of you are aware about what's happening with MongoDB and Elastic Search databases. Take a look at this article: http://www.pcworld.com/article/3157417/security/after-mongodb-ransomware-groups-hit-exposed-elasticsearch-clusters.html . OrientDB's average level of security is much stronger than both MongoDB and ElasticSearch. But nothing can keep you totally safe, specially if you are exposing an OrientDB server directly to the Internet and/or you haven't changed the default password in your database. So here a *5 minutes* action plan to keep your OrientDB safer. 1. If you aren't using the default users (admin, reader and writer), then delete them 2. If you're using them, be sure you changed the password to all of these 3 default users: admin, reader and writer 3. When you have installed OrientDB the first time, the script asked for the root's password. Well, be sure you don't have something obvious like "root", "orientdb", "password", etc. Now a few advice to keep OrientDB even more secure: 1. If you can, *don't expose the OrientDB server to the Internet* 2. Remember that starting from v2.2 you can configure a stronger *SALT* cycles for hashed password. Look at: http://orientdb.com/docs/2.2/Database-Security.html#password-management 3. If you're working with very sensitive data, please consider to use Encryption at REST using AES algorithm: http://orientdb.com/docs/2.2/Database-Encryption.html. More Resources: - Database Security <http://orientdb.com/docs/2.2/Database-Security.html> - Server Security <http://orientdb.com/docs/2.2/Server-Security.html> For any question, don't hesitate to followup on this message. Thanks. Best Regards, Luca Garulli Founder & CEO OrientDB LTD -- --- 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.
Re: [orientdb] Re: Proper way to generate and insert data into OrientDB
Hi Cyprien, Glad you solved it. With remote and/or graph operations, specially when you add multiple edges, transaction always help. Before 2.2 transactions didn't run in parallel, but after 2.2 they can. In facts, this is my next question. Are you running on multiple threads? Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> On 5 January 2017 at 15:44, Cyprien Gottstein wrote: > Hi, > > The scripts are in java, those are not batches, and we didn't wanted to > post it online to be perfectly honest. > > But. > > Great news, problem solved ! > > I remembered something crucial, it's mainly me who is working on the > subject and at first i wanted to run the OrientDB server on my own local > machine. Since my computer is not what i would call young and powerful, i > asked to make it run on a virtual machine in our own datacenter. I work in > France. The Datacenter is in Poland. > > What was it again ? Non-Transactionnal Mode means " for every new entity > we write it immediately on disk ", it meant for every entry we were eating > the latency between our building in France and the datacenter in Poland. > > We made a proper uber-jar to run the generation code on the very same > machine holding the Orient DB server's instance. > We did some simple benchmark to check how the total execution time would > behave depending on the transaction mode and location of the program. > > Job Place - Transactionnal : 900 secs (i don't have the real number, i > just know its around that, sorry.) > Job Place - Non-Transactionnal : more than 54000 secs > Datacenter - Transactionnal : 212 secs > Datacenter - Non-Transactionnal : 2700 secs (i don't have the real number, > i just know its around that, sorry.) > > So thanks to executing the code from the right place we avoided some HUGE > loss of times. The Non-Transactionnal mode is slower but your promess was > kept, it runs with a constant amount of RAM, that means if we want to > generate 10 millions or even 50 millions of entities we can in a > reasonnable time so i would guess it's fine. > > Last question and i think this case will be closed (at least for me) : > > The OrientDB Documentation warns in http://orientdb.com/docs/last/ > Performance-Tuning.html#wise-use-of-transactions that : > > "Transactions slow down massive inserts unless you're using a "remote" >> connection. In that case it speeds up all the insertion because the >> client/server communication happens only at commit time." >> > > We can indeed see it in effect when we run our little benchmark > (Transactionnal - 212 VS Non-Transactionnal 2700) , are we in a difference > of speed that is to be expected ? Or does something still feels off ? > > Thanks again for your time, > > Cyprien Gottstein > > -- > > --- > 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.
[orientdb] After SF, OrientDB will be in Seattle on January 18th
After San Francisco I will be in Seattle, USA, on January 18th to talk about Graphs, Multi-Model and OrientDB, of course. The event is totally FREE. If you are in Seattle or close to it, you can find me here: https://www.meetup.com/Seattle-Bellevue-Graphs/events/236517483/ Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> -- --- 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.
Re: [orientdb] Re: Proper way to generate and insert data into OrientDB
Hi Cyprien, Could you please attach your BATCH script that executed bulk inserts? Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> On 2 January 2017 at 14:09, Cyprien Gottstein wrote: > Hello everyone, > > I'm back from holidays, i had the time to patch the generator in > non-transactionnal mode and it works ! Sadly, the insert rate has been > divided by something like... 50 times ? > We guessed it would be slower, but didn't thought the gap would be this > large. > > We will run it once more to have actual numbers/rate for each mode. > > Anyway, We also thought about writing "Big File" full of insert lines to > do some bulk insert but we encountered an unexpected problem. If we insert > a new element (be it an edge or a vertex) we can't force manually the @rid. > Consequently, we can't write easily all the edges between the vertices > because we do not have any way to know in advance the proper vertice's > @rids. > > We did some research, the workaround is to use subqueries in the insert to > retrieve the vertices to bind. But that means OrientDB will have to perform > two subquery for each edge to insert, it will probably work but we highly > doubt > it will be faster than the non-transactionnal mode and in the end we would > have done this for nothing. > > Are we, once more, missing something ? Or is writing large insertion file > just not a good idea for OrientDB (at least in the case you have lots of > edges) ? > > Thanks a lot and Happy new year ! > > Cyprien Gottstein. > > -- > > --- > 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.
[orientdb] OrientDB in San Francisco on January 9th 2017
Hi guys, On January 9th I will begin the new year with a Meetup in the Bay Area: https://www.meetup.com/silicon-valley-graph/events/236517152/ I'd like to meet the OrientDB users that work in the Valley, it'd be really awesome if you can make it. Happy New Year, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> -- --- 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.
Re: [orientdb] spring-data-orientdb
Hi Joao, The OrientDB Spring Data module is already used in production by a few companies now and it's officially supported by the OrientDB team. Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> On 29 December 2016 at 13:39, João Batista de Andrade wrote: > > > Hi Guys. I'm new with OrientDB. I'm starting a new project and i'm > thinking in making with Spring and OrientDB. > > The spring-data-orientdb ( https://mvnrepository.com/artifact/com. > orientechnologies/spring-data-orientdb-commons/0.14rc1 ) > > is good for production? > > Thanks a lot for your attention, > > > João Batista > > -- > > --- > 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.
Re: [orientdb] Java document API when database uses a non-standard remote port
Hi Jon, Did you replaced the libraries in the client from 2.1.x to 2.2.x? Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> On 23 December 2016 at 20:37, Jon Swinth wrote: > Hi All, > > I have more than one instance of OrientDB on a server so the second > instance runs on different ports, 34xx instead of 24xx. This works fine > for the REST API and console but the Java document API does not seem to > accept the port specification. > > I wanted to verify that I'm trying to connect correctly prior to assuming > it will not work. We are currently using version 2.1.16 (DB and API) and > are trying to migrate to 2.2.x. > > String orientUrl = "remote:solapp13:3424/PortalDS" ; > com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx > database = new com.orientechnologies.orient.core.db.document. > ODatabaseDocumentTx(orientUrl).open(username,password); > > Here is the useful parts of the stack trace: > > com.orientechnologies.orient.core.exception.ODatabaseException: Cannot > open database url=remote:solapp13:3424/PortalDS > at com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx. > open(ODatabaseDocumentTx.java:281) > ... > Caused by: java.lang.NullPointerException: Name is null > at java.lang.Enum.valueOf(Enum.java:235) > at com.orientechnologies.orient.core.config.OStorageClusterConf > iguration$STATUS.valueOf(OStorageClusterConfiguration.java:24) > at com.orientechnologies.orient.core.config.OStorageConfiguration. > fromStream(OStorageConfiguration.java:263) > at com.orientechnologies.orient.core.config.OStorageConfiguration.load( > OStorageConfiguration.java:137) > at com.orientechnologies.orient.client.remote.OStorageRemote.open( > OStorageRemote.java:223) > at com.orientechnologies.orient.client.remote.OStorageRemoteThread.open( > OStorageRemoteThread.java:94) > at com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx.open > (ODatabaseDocumentTx.java:248) > ... 97 more > > > > Thanks in advance. > > > Jon > > -- > > --- > 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.
Re: [orientdb] Proper way to generate and insert data into OrientDB
Hi Cyprien, To insert 1M of graph elements you could just 100MB, but it depends about how you are doing it. A few questions: 1. are you using plocal o remote connection? 2. embedded, one server or multiple servers? 3. are you inserting using SQL COMMANDs? Or are you using regular Graph API by using vertices and edges? 4. are you using transactions? Please bear in mind that transactions consume RAM Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> On 22 December 2016 at 18:28, Cyprien Gottstein wrote: > Hello everyone, > > We are currently testing OrientDB to check if we may use it as a database. > The problem we are facing right now is about memory consumption through > data generation. > > We want to test if OrientDB support our queries in a larger scale so we > went through building a little generator in java to insert data > corresponding to our needs.In order to generate and insert the data in a > fast way we parse first ontologies (which serve for semantic data > referencing) and store them in memory. Afterwards we generate some random > data, bind them together on-the-fly and also bind them to some concepts in > the ontologies graphs. All of that is made using the Java Graph API. > > It works nicely at the beginning, but in the end it always crashes with > "java.lang.OutOfMemoryError: GC overhead limit exceeded". The java program > which handle the data generation has 1.5 GB ram to work with and when it > crashes we have almost generated a million of OrientDB elements ( about a > third as vertices, the rest as edges). > > We tried a lot of things, Massive Insert intent, setting > keepReferencesInMemory to false, limiting disk cache size, and we checked > multiple times to ensure we were not doing anything stupid with the memory. > We also thought about using fetchplan to ensure the cache only stores the > main document in memory and not all of its edges but this option is not > accessible in the Graph API.Yet, we can't make the generator go further > because it always lack memory. > > We think it's related to the disk cache usage, we can't properly measure > it but its visible in htop, the memory usage keeps growing during the last > half of the generation even though at this point we are only inserting data > in the graph and we are not storing anything anymore in the Java program. > Our theory behind this is that we store pointers to the ontology nodes > which themselves points on the nodes we generate on the fly and at some > point this may trigger the cache to keep the pointed nodes alive in memory. > This would explain why the memory keep growing. > > I'm sorry of its a bit fuzzy. > > We could just add more RAM to the JVM but we can't help but wonder: What > are we missing ? Is there a way to properly generate a set data with > connections between eachother and insert it into OrientDB ? > > Thanks, > > Cyprien Gottstein. > > > > > -- > > --- > 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.
Re: [orientdb] Re: orientdb-neo4j-importer: Importing from neo4j with multiple Labels on nodes
Hi Gregory,
I know Santo (the author of tool), already completed the multi-label
support, not by using OrientDB's classes but rather a vertex property that
is an EMBEDDEDSET that contains the set of labels as strings. So you can do
pretty much all the queries like with Neo4j.
@Santo do you have more to say about it? When the new version will be
available?
Best Regards,
Luca Garulli
Founder & CEO
OrientDB LTD <http://orientdb.com/>
On 19 December 2016 at 20:58, Oleksandr Gubchenko
wrote:
> It's not possible.
> See official documentation: http://orientdb.com/docs/last/
> OrientDB-Neo4j-Importer.html
> Limitations:
> Schema limitations:
> - In case a node in Neo4j has multiple Labels, it will be imported into a
> single OrientDB Class ("MultipleLabelNeo4jConversion").
> -- Note that the information about the original set of Labels is not lost
> but stored into an internal property of the imported vertex
> ("Neo4jLabelList"). As a result it will be possible to query nodes with a
> specific Neo4j Label. Note also that the nodes imported into the single
> class "MultipleLabelNeo4jConversion" can then be moved to other Classes,
> according to your specific needs, using the MOVE VERTEX command.
> - Neo4j Nodes with same Label but different case, e.g. LABEL and LAbel
> will be aggregated into a single OrientDB vertex Class.
>
>
> Alex.
>
> Il giorno lunedì 19 dicembre 2016 20:13:12 UTC+1, Gregory Mace ha scritto:
>>
>>
>> I've imported several millions of records from Neo4j. They all came
>> over, but the class type is not what I wanted them to be. I have some
>> questions:
>>
>> 1. can orientdb represent Vertexes similar to Neo4j in terms of
>> supporting multiple Labels on a Vertex. If so, how?
>> 2. how can I bulk change the classes of records ( Vertexes ) that I
>> imported from Neo4j?
>> 3. Is there a way to pre-define how I want an import to assign classes?
>>
> --
>
> ---
> 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.
Re: [orientdb] Is OrientDB good for many user?
Hi JiHyun, OrientDB is already used in large banks and large organizations. Some of them are Fortune500 companies. Look at the website to see some of them. Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> On 18 December 2016 at 14:27, JiHyun Kim wrote: > Hi, I'm first in this community. > I'm very happy to meet OrientDB. > But I have a question. > I am curious about the capacity of OrientDB. > e.g. bank system or big online system. > > > -- > > --- > 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.
Re: [orientdb] Re: Mass insertion of vertices very slow, is it necessary Performance Tuning?
Ok, when you create edges, how do you look for a vertex if it already exists? Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> On 1 December 2016 at 14:22, Aceitunas y encurtidos Quijote < encurtidosquij...@gmail.com> wrote: > If I am doing searches to add edges and I do not have indexes > > El jueves, 1 de diciembre de 2016, 13:02:09 (UTC+1), l.garulli escribió: >> >> Are you doing lookups and in this case, do you have indexes defined on >> the lookup fields? >> >> Best Regards, >> >> Luca Garulli >> Founder & CEO >> OrientDB LTD <http://orientdb.com/> >> >> On 1 December 2016 at 08:48, Aceitunas y encurtidos Quijote < >> encurtid...@gmail.com> wrote: >> >>> Hello, you are finished inserting: >>> Inserted 1000 EHRs, 10 compositions in 58062579 ms. >>> >>> The size of the database is 940mb >>> >>> -- >>> >>> --- >>> 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-databa...@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. > -- --- 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.
Re: [orientdb] Re: Mass insertion of vertices very slow, is it necessary Performance Tuning?
Are you doing lookups and in this case, do you have indexes defined on the lookup fields? Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> On 1 December 2016 at 08:48, Aceitunas y encurtidos Quijote < encurtidosquij...@gmail.com> wrote: > Hello, you are finished inserting: > Inserted 1000 EHRs, 10 compositions in 58062579 ms. > > The size of the database is 940mb > > -- > > --- > 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.
Re: [orientdb] Re: [HELP] Can I retrieve them in the same order in which they were saved?
Hi, You should use a LIST as type, rather than a set or ridbag (for links). Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> Want to share your opinion about OrientDB? Rate & review us at Gartner's Software Review <https://www.gartner.com/reviews/survey/home> On 23 November 2016 at 12:59, Academia Learning Centro de inglés y de formación wrote: > I have the same problem > > > El miércoles, 23 de noviembre de 2016, 12:23:34 (UTC+1), roberto carlos > diaz justicia escribió: >> >> When I retrieve a json the fields are in different order than when saved >> >> Can I get them back in the same order? >> > -- > > --- > 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.
Re: [orientdb] Re: [Announcement] OrientDB and TinkerPop 3
On 10 November 2016 at 01:00, odbuser wrote: > Yes this is amazing news. I'm curious about the following: > > What is the performance like? > What do you mean? In comparison to TP2? > What part of Tinkerpop 3 is supported? > Now only a limited set of features are supported, we're working to extent them to support most of them soon. > What is the impact and transition for users who are currently using > OrientDB with Tinkerpop 2 apis such as Frames? > Don't worry, existent users could continue using the old API through the OrientDB-TinkerPop-2 external plugin. Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> Want to share your opinion about OrientDB? Rate & review us at Gartner's Software Review <https://www.gartner.com/reviews/survey/home> > > --- > 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.
[orientdb] [Announcement] OrientDB and TinkerPop 3
Hi guys, I'm glad to announce that the OrientDB Team has started supporting officially the TinkerPop 3 standard in the "develop" branch, namely OrientDB v3.0. Michael Pollmeier (@mpollmeier), the author of the already excellent OrientDB-Gremlin driver, transferred it under the OrientDB umbrella: https://github.com/orientechnologies/orientdb-gremlin Together with Michael, also Marvin Froeder (@velo) joined the team as committer of the project. They will work, together with the OrientDB team, to make this driver ready for OrientDB v3.0. From the OrientDB side, the owner of this project is Enrico Risa (@maggiolo00). Guys, we're looking for new contributors. The roadmap is still open. So far the most important things are: 1. Better support for indexes 2. Usage of the new GraphAPI in the OrientDB core 3.0 3. Better coverage of TinkerPop 3 features By transferring the original project the entire history and issues are preserved. if you are already using it, please reset the master source of the git repository to it. *Is this an amazing news?* <https://github.com/orientechnologies/orientdb-gremlin> Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> Want to share your opinion about OrientDB? Rate & review us at Gartner's Software Review <https://www.gartner.com/reviews/survey/home> -- --- 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.
Re: [orientdb] Code review questions
On 14 October 2016 at 17:12, Shahim Essaid wrote: > Hi, > Hi Shahim, What is the best way to ask questions if I'm reviewing some code and I > think I see a problem, or I need some clarification? I know GitHub has a > commenting feature for pull requests and on blame views but there is no way > to simply place comments on arbitrary lines in current files. I also > looked for an issue label like "code review" or something similar and I > didn't notice one. > > Examples of what I'm talking about are: > > 1. Why is there no checkSecurity here: > > https://github.com/orientechnologies/orientdb/blob/ > b431805894b2599c3c7b4f066d31800ca504b389/core/src/main/java/ > com/orientechnologies/orient/core/db/document/ > ODatabaseDocumentTx.java#L1348 > > as seen for the similar method here: > > https://github.com/orientechnologies/orientdb/blob/ > b431805894b2599c3c7b4f066d31800ca504b389/core/src/main/java/ > com/orientechnologies/orient/core/db/document/ > ODatabaseDocumentTx.java#L1365 > You're right it's missing. > 2. Database listeners are sometimes called for onBeforeTxBegin before the > actual transaction object is set for the database. Is this intentional? > Examples: > > https://github.com/orientechnologies/orientdb/blob/ > b431805894b2599c3c7b4f066d31800ca504b389/core/src/main/java/ > com/orientechnologies/orient/core/db/document/ > ODatabaseDocumentTx.java#L1736 > > https://github.com/orientechnologies/orientdb/blob/ > b431805894b2599c3c7b4f066d31800ca504b389/core/src/main/java/ > com/orientechnologies/orient/core/db/document/ > ODatabaseDocumentTx.java#L2284 > It's intentional, also the method's name onBeforeTxBegin() tells it's called before the transaction begins. > 3. DRY > > https://github.com/orientechnologies/orientdb/blob/ > b431805894b2599c3c7b4f066d31800ca504b389/core/src/main/java/ > com/orientechnologies/orient/core/db/document/ > ODatabaseDocumentTx.java#L2341 > > can simply be this.freeze(false); > > I'm starting to study some of the code and I'm sure I'll have many similar > questions. Should these be issues? One issue per file? Which label should I > use? > You're right, it could call that methof. WDYT about sending a Pull Request on GitHub against the develop branch? I'd be more than happy to accept it. Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> Want to share your opinion about OrientDB? Rate & review us at Gartner's Software Review <https://www.gartner.com/reviews/survey/home> > > Best, > Shahim > > -- > > --- > 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.
Re: [orientdb] LiveQuery vs. RethinkDB Changefeeds
Hi Anthony,
I was waiting for a post like yours where we can understand better what is
missing in OrientDB to provide the same level of reactiveness of RethinkDB.
I leave to @Luigi to comment this email point by point.
However, even if the Live Query feature is a quite new feature in OrientDB,
it's definitely one of the main things where we are focusing on.
Thanks.
Best Regards,
Luca Garulli
Founder & CEO
OrientDB LTD <http://orientdb.com/>
Want to share your opinion about OrientDB?
Rate & review us at Gartner's Software Review
<https://www.gartner.com/reviews/survey/home>
On 11 October 2016 at 16:03, Anthony wrote:
> Now that RethinkDB is shutting down, I have been looking at OrientDB,
> particularly its LiveQuery feature. I am interested in the extent to which
> LiveQuery is comparable to RethinkDB Changefeeds. In particular:
>
>- Are there any limitations on the types of queries with which
>LiveQuery works? Can you put "LIVE" in front of any "SELECT" command and
>get a working LiveQuery?
>- More specifically, does LiveQuery work on queries involving links?
>For example, suppose you have a query that retrieves a set of blog posts
>and their linked comments -- does the LiveQuery send a change notification
>when a linked comment is inserted/updated/deleted in the LINKLIST?
>- In RethinkDB, changefeeds involving orderby and limit can be
>configured to send the old and new offset of each change (via the
>include_offsets option) so you can easily insert the change into the proper
>place within the previously returned set of records. Is this possible with
>LiveQuery, or do you have to manage the ordering manually on the client?
>- If you want the initial set of records followed by any subsequent
>changes, do you have to issue an initial SELECT followed by a LIVE SELECT?
>If so, is there any way to ensure you don't miss any changes between the
>two (RethinkDB achieves this with its include_initial option).
>- Can OrientDB do filtering on the changes themselves? For example, in
>RethinkDB, you can do:
>
>
> r.table('test').changes().filter{ |row|
> row['new_val']['score'] > row['old_val']['score']
> }
>
> The above changefeed will only return changes where the new score is
> greater than the old score. Is this possible with live queries?
>
>- Does LiveQuery have anything similar to the RethinkDB "squash"
>option, which can be set to squash a set of changes that happen within a
>particular timespan into just a single change?
>- How scalable are live queries? If you have a web application with
>tens or hundreds of thousands of connected users, each user with several of
>their own unique live queries, will OrientDB be able to handle that. The
>RethinkDB Horizon docs claim it is "designed to support millions of
>realtime feeds" (with proper horizontal scaling of the database). Is
>OrientDB in the same league? What kind of load would be realistic for a
>single server, and is there any bottleneck that would inhibit horizontal
>scaling to support more and more live queries?
>- Any other notable differences from RethinkDB changefeeds?
>
> More generally, what is OrientDB's commitment to developing and promoting
> the LiveQuery feature? RethinkDB promotes its changefeeds as its primary
> distinguishing feature ("The open-source database for the realtime web").
> However, it does not appear that LiveQuery is mentioned *anywhere *on the
> marketing parts of the OrientDB website (except for a single year-old blog
> post), and you have to dig fairly deep in the documentation to discover the
> feature even exists. Is this feature a priority for OrientDB?
>
> Finally, given RethinkDB's recent fate, it would be nice to know more
> about the health of OrientDB LTD. Is the company profitable and poised to
> be around for a while?
>
> Thank you.
>
> Anthony
>
> --
>
> ---
> 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.
Re: [orientdb] Re: custom function returns the same result
Hi, I'm not sure to have understood the problem. The function called
against #25:0 and #26:0 should return a different value than 1?
By the way, you could also use this:
orient.getDatabase().query( "select out('hasCommentary').size() as
countComment from " + idBusiness );
hasCommentary should be in quotes if it's the name of the edge's class.
Furthermore size() works better with collections (but the result should be
the same). Last thing, you can use the RID directly in the FROM clause.
Best Regards,
Luca Garulli
Founder & CEO
OrientDB LTD <http://orientdb.com/>
Want to share your opinion about OrientDB?
Rate & review us at Gartner's Software Review
<https://www.gartner.com/reviews/survey/home>
On 7 October 2016 at 17:31, Oleksandr Gubchenko
wrote:
> Hi, I see a negative rid in your output, can you try with this code?
>
> var g= orient.getGraph();
> var query= g.command("sql","YOUR_QUERY_HERE");
> return query;
>
>
>
> Il giorno sabato 8 ottobre 2016 00:19:59 UTC+2, Renzo Ludeña ha scritto:
>>
>> Hello friends, I created a function in orientdb studio use the version
>> 2.2.4 but when I called me back the same result for all
>>
>>
>>
>> <https://lh3.googleusercontent.com/-VFeOpGunTiI/V_gfGYS7SKI/APU/ZStkhK4QAVAx7ZnwlJ8nfb2kQl_0bwIWQCLcB/s1600/Selection_025.png>
>>
>>
>>
>>
>>
>>
>> <https://lh3.googleusercontent.com/-yuND7l_JOac/V_gfcfsiAZI/APY/pdpR_mPOzxMFjsTNEisa9obl0Zsz2fIZACLcB/s1600/Selection_026.png>
>>
>>
>> thanks for your help
>>
> --
>
> ---
> 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.
Re: [orientdb] Schema Migration/Evolution Tool
Hi Amir, Thanks for your contribution. Could you please write in the README.md how the script works, when it's useful and what's the syntax? Thanks. Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> Want to share your opinion about OrientDB? Rate & review us at Gartner's Software Review <https://www.gartner.com/reviews/survey/home> On 3 October 2016 at 17:23, Amir Khawaja wrote: > Hello Everyone. I have published some shell scripts to help with applying > schema migrations to an existing OrientDB database. A blog post will follow > talking about this tool. Your comments and feedback are welcome. Here is > the Git repo URL: https://github.com/akhawaja/orientdb-schema-migration > > Amir. > > -- > > --- > 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.
Re: [orientdb] Unable to list connections
The connections as per server, so you should connect to the server, not to
the database. Try doing:
*connect remote:localhost root*
Best Regards,
Luca Garulli
Founder & CEO
OrientDB LTD <http://orientdb.com/>
Want to share your opinion about OrientDB?
Rate & review us at Gartner's Software Review
<https://www.gartner.com/reviews/survey/home>
On 30 September 2016 at 00:12, wrote:
> Hello guys,
>
> I'm new to OrientDB and trying to simply list connections but puzzled here
> if I'm doing something wrong or is it a bug. Every time I execute "list
> connections" I get an error message. I tried with root and admin users to
> no avail. Here are the steps I followed:
>
>
> iMac:developer mike$ orientdb-community-2.2.10/bin/console.sh
>
>
> OrientDB console v.2.2.10 (build
> 2.2.x@rc32d4ee06d4c38e27eb66931d027eb54854872ff;
> 2016-09-15 08:47:27+) www.orientdb.com
>
> Type 'help' to display all the supported commands.
>
> Installing extensions for GREMLIN language v.2.6.0
>
>
> orientdb> *connect remote:localhost/Customers root*
>
> Enter password:
>
>
> Connecting to database [remote:localhost/Customers] with user 'root'...OK
>
> orientdb {db=Customers}> *list indexes*
>
>
> INDEXES
>
> ++--+-+---+-+---
> +---+
>
> |# |NAME |TYPE |RECORDS|CLASS|COLLATE|FIELDS
> |
>
> ++--+-+---+-+---
> +---+
>
> |0 |accessKey |UNIQUE |8 |Account
> |default|accessKey(STRING) |
>
> |1 |accountId |UNIQUE |8 |Account
> |default|id(INTEGER)|
>
> |2 |dictionary|DICTIONARY |0 | |default|
> |
>
> |3 |OFunction.name|UNIQUE_HASH_INDEX|0 |OFunction|default|name(STRING)
> |
>
> |4 |ORole.name|UNIQUE |3 |ORole|ci
> |name(STRING) |
>
> |5 |OUser.name|UNIQUE |3 |OUser|ci
> |name(STRING) |
>
> |6 |purchaseKey |UNIQUE |8 |Account
> |default|purchaseKey(STRING)|
>
> |7 |settingsKey |UNIQUE |1 |Settings
> |default|key(STRING)|
>
> |8 |systemIP |UNIQUE |3 |systemIP
> |default|ip(STRING) |
>
> |9 |userEmail |UNIQUE |3 |User
> |default|email(STRING) |
>
> ++--+-+---+-+---
> +---+
>
> ||TOTAL | |37 | | |
> |
>
> ++--+-+---+-+---
> +---+
>
> orientdb {db=Customers}> *list connections*
>
>
> Not connected to the Server instance. You've to connect to the Server
> using server's credentials (look at orientdb-*server-config.xml file)
>
> orientdb {db=Customers}>
>
>
> As you can see, I am connected to the database and can run queries, but
> not "list connections" one.
>
> --
>
> ---
> 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.
Re: [orientdb] Seeking speakers/presentations for Graph Day Texas 2017
Hi guys, I was in Austin last January for the previous edition and it was an *amazing event*. Can you imagine one full day speaking about graphs? If anybody can be in Austin for this edition it would be awesome. Whatever presentation related to OrientDB, we can send a gadget pack ;-) Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> Want to share your opinion about OrientDB? Rate & review us at Gartner's Software Review <https://www.gartner.com/reviews/survey/home> On 29 September 2016 at 22:23, Lynn Bender wrote: > Fellow Graph Pros, > > The 2nd annual Graph Day Texas will be held in Austin on January 14. > http://graphday.com > > This time it will be part of the larger Data Day Texas (which had 750+ > attendees last year). > http://datadaytexas.com > > Last time Luca joined us as a speaker. > > If any of you have a great use case, or are doing something cool that > you'd like to share with the global graph community, please consider > joining us. We'd love to see OrientDB represented. > > Details for proposals are on the proposals page: > http://graphday.com/proposals > > Graph Day SF is in the works. > > Cheers, > > LynnBender > http://twitter.com/linearb > http://www.linkedin.com/in/lynnbender/ > >- > > -- > > --- > 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.
Re: [orientdb] Re: Performance of Distributed (3 nodes) cluster with one billion edges
On 27 September 2016 at 08:03, Phillip Henry wrote: > Hi, Luca. > > I've now tried OGraphBatchInsert. It is indeed much faster at about 4.5 > hours for the billion payments. Slower than Neo but we can live with that. > Hi Phillip, Good to know it worked. Are you using last v2.2.10 right? > However, I'm having trouble getting a full run. > > I'm getting OutOfMemory errors with -XX:MaxDirectMemorySize=512G and > combinations of: > > -Xmx51443M -Dstorage.diskCache.bufferSize=60059 > -Xmx90G -Dstorage.diskCache.bufferSize=10240 > -Xmx90G -Dstorage.diskCache.bufferSize=8192 > > So, I've now increased MaxDirectMemorySize to 999G but with no success > (this box has 128GB of memory). > > On a box with about 250GB where I can increase the heap, it ran to the > end. There was some SEVEREs at the beginning that said "Previous maximum > cache size was 3474813 current maximum cache is 278528. Cache state for > storage /home/d3956122/OrientDB/databases/MyPayments3 will not be > restored" and some "Exception during commit of active transaction... > Database /home/d3956122/OrientDB/databases/MyPayments3 is closed". But > after that things seem to go well. I hope these initial errors are not too > serious? > So It looks like 128GB wasn't enough. About the two exception, let me ask to the team first. About the second one "Exception during commit of active transaction... Database /home/d3956122/OrientDB/databases/MyPayments3 is closed" do you have the stack trace? > > Unfortunately, there was a hiccup in my coding where the app doesn't > naturally die when all the writing is over (I never stop the thread pool - > oops). However, it was a day or two later when I killed it. After I killed > the processes, I was surprised to see only a few hundred vertices in the > plocal database when I was expecting to see one million (the number of > edges was much closer to what I expected). At what point are the vertices > flushed? Can I flush them via the API? > Do you mean with the batch API? Did you call the end() ? > Regards, > > Phillip > Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> Want to share your opinion about OrientDB? Rate & review us at Gartner's Software Review <https://www.gartner.com/reviews/survey/home> > > > On Friday, September 23, 2016 at 6:27:02 PM UTC+1, l.garulli wrote: >> >> On 23 September 2016 at 11:23, Phillip Henry wrote: >> >>> > will there not be potential contention when the "to" vertex is updated? >>> >>> Ah, just re-read your post and you've already answered this. My >>> apologies. >>> >> >> Yes, the idea is that with millions and mullions of vertices, the chance >> to have a collision with the target nodes is very low, unless you have >> supernodes that recurs in most of the relationships. >> >> >>> >>>> > OGraphBatchInsert ... keeps everything in RAM before flushing >>>> >>>> I assume I will still have to write retry code in the event of a >>>> collision (see above)? >>>> >>> >> No in this case, the batch insert will manage this for you. >> >> >> Luca >> >> > -- > > --- > 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.
Re: [orientdb] spring-session-orientdb 1.0 is released
Hi Miron, Thanks for the project. I've just added it in our (messy) plugin page (it should be online in a few minutes): http://orientdb.com/docs/last/Plugins.html Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> Want to share your opinion about OrientDB? Rate & review us at Gartner's Software Review <https://www.gartner.com/reviews/survey/home> On 26 September 2016 at 13:36, Miron Aseev wrote: > Hey, everyone. > > I just want to share some information about a project I've been working on > recently - spring-session-orientdb > <https://github.com/maseev/spring-session-orientdb>. > It's a Spring Session extension for OrientDB. So, if you're using Spring > and OrientDB in your project, you might take a look at this little library. > > Hope you find it useful. > > -- > > --- > 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.
Re: [orientdb] Re: How do I connect via console to a server running on localhost only?
You found it! Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> Want to share your opinion about OrientDB? Rate & review us at Gartner's Software Review <https://www.gartner.com/reviews/survey/home> On 23 September 2016 at 10:55, William wrote: > Hi Luca, > > I just looked for the issue but was unable to find it in either the list > of open or closed issues. This is the correct place to look > <https://github.com/orientechnologies/orientdb/issues?q=is%3Aissue+is%3Aclosed>, > right? > > I believe I did find the commit > <https://github.com/orientechnologies/orientdb/commit/50626778d2fb73540d9e8d81b3491821f06e2e6d> > though. :) > > Thanks! > -William > > On Thursday, September 22, 2016 at 5:45:49 PM UTC-6, l.garulli wrote: >> >> Hi William, >> >> This was a bug I fixed yesterday: the console converted the localhost to >> the public IP. It's fixed in v2.2.x branch. >> >> Have you read the issue and its comments? >> >> Best Regards, >> >> Luca Garulli >> Founder & CEO >> OrientDB LTD <http://orientdb.com/> >> >> Want to share your opinion about OrientDB? >> Rate & review us at Gartner's Software Review >> <https://www.gartner.com/reviews/survey/home> >> > -- > > --- > 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.
Re: [orientdb] Re: Performance of Distributed (3 nodes) cluster with one billion edges
On 23 September 2016 at 11:23, Phillip Henry wrote: > > will there not be potential contention when the "to" vertex is updated? > > Ah, just re-read your post and you've already answered this. My apologies. > Yes, the idea is that with millions and mullions of vertices, the chance to have a collision with the target nodes is very low, unless you have supernodes that recurs in most of the relationships. > >> > OGraphBatchInsert ... keeps everything in RAM before flushing >> >> I assume I will still have to write retry code in the event of a >> collision (see above)? >> > No in this case, the batch insert will manage this for you. Luca -- --- 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.
Re: [orientdb] Re: Performance of Distributed (3 nodes) cluster with one billion edges
On 23 September 2016 at 03:50, Phillip Henry wrote: > > How big is your file the sort cannot write? > > One bil-ee-on lines... :-P > How many GB? > > ...This should help a lot. > > The trouble is that the size of a block of contiguous accounts in the real > data is not-uniform (even if it might be with my test data). Therefore, it > is highly likely a contiguous block of account numbers will span 2 or more > batches. This will lead to a lot of contention. In your example, if Account > 2 spills over into the next batch, chances are I'll have to rollback that > batch. > > Don't you also have a problem that if X, Y, Z and W in your example are > account numbers in the next batch, you'll also get contention? Admittedly, > randomization doesn't solve this problem either. > If the file is ordered, you could have X threads (where X is the number of cores) that parse the file not sequentially. For example with 4 threads, you could start the parsing in this way: Thread 1, starts from 0 Thread 2, starts from length * 1/4 Thread 3, starts from length * 2/4 Thread 1, starts from length * 3/4 Of course the parsing should browse until the next LF+LR if it's a CSV. It requires some lines of code, but you could avoid many conflicts. > > you can use the special Batch Importer: OGraphBatchInsert > > Would this not be subject to the same contention problems? > At what point is it flushed to disk? (Obviously, it can't live in heap > forever). > It keeps everything in RAM before flushing. Up to a few hundreds of millions of vertices/edges should be fine if you have a lot of heap, like 58GB (and 4GB of DISKCACHE). It depends by the number of attributes you have. > > You should definitely using transactions with batch size of 100 items. > > I thought I read somewhere else (can't find the link at the moment) that > you said only use transactions when using the remote protocol? > This was true before v2.2. With v2.2 the management of the transaction is parallel and very light. Transactions work well with graphs because every addEdge() operation is 2 update and having a TX that works like a batch really helps. > > > Please use last 2.2.10. ... try to define 50GB of DISKCACHE and 14GB of > Heap > > Will do on the next run. > > > If happens again, could you please send a thread dump? > > I have the full thread dump but it's on my work machine so can't post it > in this forum (all access to Google Groups is banned by the bank so I am > writing this on my personal computer). Happy to email them to you. Which > email shall I use? > You cna use support --at- orientdb.com referring at this thread in the subject. > > Phill > Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> Want to share your opinion about OrientDB? Rate & review us at Gartner's Software Review <https://www.gartner.com/reviews/survey/home> > On Friday, September 23, 2016 at 7:41:29 AM UTC+1, l.garulli wrote: > >> On 23 September 2016 at 00:49, Phillip Henry wrote: >> >>> Hi, Luca. >>> >> >> Hi Phillip. >> >> >>> I have: >>> >>> 4. sorting is an overhead, albeit outside of Orient. Using the Unix sort >>> command failed with "No space left on device". Oops. OK, so I ran my >>> program to generate the data again, this time it is ordered by the first >>> account number. Performance was much slower as there appeared to be a lot >>> of contention for this account (ie, all writes were contending for this >>> account, even if the other account had less contention). More randomized >>> data was faster. >>> >> >> How big is your file the sort cannot write? Anyway, if you have the >> accounts sorted, you should have transactions of about 100 items where the >> bank account and edges are in the same transaction. This should help a lot. >> Example: >> >> Account 1 -> Payment 1 -> Account X >> Account 1 -> Payment 2 -> Account Y >> Account 1 -> Payment 3 -> Account Z >> Account 2 -> Payment 1 -> Account X >> Account 2 -> Payment 1 -> Account W >> >> If the transaction batch is 5 (I suggest you to start with 100), all the >> operations are executed in one transaction. In another thread has: >> >> Account 99 -> Payment 1 -> Account W >> >> It could go in conflict because the shared Account W. >> >> If you can export Account's IDs that are numbers and incremental, you can >> use the special Batch Importer: OGraphBatchInsert. Example: >> >> OGraphBatchInsert batch = new OGraphBatchI
Re: [orientdb] Re: Performance of Distributed (3 nodes) cluster with one billion edges
k writes per
> second, I'm looking at about 20 hours of loading. We've taken the same data
> and, after trial and error that was not without its own problems, put it
> into Neo4J in 37 minutes. This is a significant difference. It appears that
> they are approaching the problem differently to avoid contention on
> updating the vertices during an edge write.
>
With all this suggestion you should be able to have much better numbers. If
you can use the Batch Importer the number should be close to Neo4j.
>
> Thoughts?
>
> Regards,
>
> Phillip
>
>
Best Regards,
Luca Garulli
Founder & CEO
OrientDB LTD <http://orientdb.com/>
Want to share your opinion about OrientDB?
Rate & review us at Gartner's Software Review
<https://www.gartner.com/reviews/survey/home>
>
> On Thursday, September 15, 2016 at 10:06:44 PM UTC+1, l.garulli wrote:
>>
>> On 15 September 2016 at 09:54, Phillip Henry wrote:
>>
>>> Hi, Luca.
>>>
>>
>> Hi Phillip,
>>
>> 3. Yes, default configuration. Apart from adding an index for ACCOUNTS, I
>>> did nothing further.
>>>
>>
>> Ok, so you have writeQuorum="majority" that means 2 sycnhronous writes
>> and 1 asynchronous per transaction.
>>
>>
>>> 4. Good question. With real data, we expect it to be as you suggest:
>>> some nodes with the majority of the payments (eg, supermarkets). However,
>>> for the test data, payments were assigned randomly and, therefore, should
>>> be uniformly distributed.
>>>
>>
>> What's your average in terms of number of edges? <10, <50, <200, <1000?
>>
>>
>>> 2. Yes, I tried plocal minutes after posting (d'oh!). I saw a good
>>> improvement. It started about 3 times faster and got faster still (about 10
>>> times faster) by the time I checked this morning on a job running
>>> overnight. However, even though it is now running at about 7k transactions
>>> per second, a billion edges is still going to take about 40 hours. So, I
>>> ask myself: is there anyway I can make it faster still?
>>>
>>
>> Here it's missing the usage of AUTO-SHARDING INDEX. Example:
>>
>> accountClass.createIndex("Account.number",
>> OClass.INDEX_TYPE.UNIQUE.toString(), (OProgressListener) null, (ODocument)
>> null,
>> "AUTOSHARDING", new String[] { "number" });
>>
>> In this way you should go more in parallel, because the index is
>> distributed across all the shards (clusters) of Account class. you should
>> have 32 of them by default because you have 32 cores.
>>
>> Please let me know if by sorting the from_accounts and with this change
>> if it's much faster.
>>
>> This is the best you can have out of the box. To push numbers up it's
>> slightly more complicated: you should be sure that transactions go in
>> parallel and they aren't serialized. This is possible by playing with
>> internal OrientDB settings (mainly the distributed workerThreads), by
>> having many clusters per class (You could try with 128 first and see how
>> it's going).
>>
>>
>>> I assume when I start the servers up in distributed mode once more, the
>>> data will then be distributed across all nodes in the cluster?
>>>
>>
>> That's right.
>>
>>
>>> 3. I'll return to concurrent, remote inserts when this job has finished.
>>> Hopefully, a smaller batch size will mean there is no degradation in
>>> performance either... FYI: with a somewhat unscientific approach, I was
>>> polling the server JVM with JStack and saw only a single thread doing all
>>> the work and it *seemed* to spend a lot of its time in ODirtyManager on
>>> collection manipulation.
>>>
>>
>> I think it's because you didn't use the AUTO-SHARDING index. Furthermore
>> running distributed, unfortunately, means the tree ridbag is not available
>> (we will support it in the future), so every change to the edges takes a
>> lot of CPU to demarshall and marshall the entire edge list everytime you
>> update a vertex. That's why my recommendation about sorting the vertices.
>>
>>
>>> I totally appreciate that performance tuning is an empirical science,
>>> but do you have any opinions as to which would probably be faster:
>>> single-threaded plocal or multithreaded remote?
>>>
>>
>> With v2.2 yo can go in parallel, by using the tips above. For sure the
>> replication has a cost. I'
Re: [orientdb] Re: How do I connect via console to a server running on localhost only?
Hi William, This was a bug I fixed yesterday: the console converted the localhost to the public IP. It's fixed in v2.2.x branch. Have you read the issue and its comments? Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> Want to share your opinion about OrientDB? Rate & review us at Gartner's Software Review <https://www.gartner.com/reviews/survey/home> On 22 September 2016 at 18:39, William wrote: > Sorry, I'm not sure I'm following you. I changed the only listener ip > address locations that I can find in the entire configuration directory to > 127.0.0.1... it's only on the two lines in orientdb-server-config.xml as I > referenced... but console ignores that. > > Can you provide more detail? Is there a different file that I need to > edit? Is there a new element that needs to be added to the configuration > XML file? > > Thanks! > -William > > > On Thursday, September 22, 2016 at 5:06:19 PM UTC-6, Ivan Mainetti wrote: >> >> Hi, >> in the listener configuration ip-address you need to insert the allowed >> source ip, for example if you want to allow only connection from your >> machine you need to insert your actual ip of net interface not the loopback >> one (127.0.0.1). >> Hope this is clear. >> >> Ivan >> >> Il giorno venerdì 23 settembre 2016 00:31:40 UTC+2, William ha scritto: >>> >>> Can anyone confirm this behavior... I'm not sure if it's a bug or if I'm >>> just doing something wrong... >>> >>> I noticed yesterday that when I fire up the server.sh application, the >>> default behavior is to listen on an outward facing port on my machine... >>> >>> 2016-09-22 16:08:35:815 INFO OrientDB Studio available at http://>> ACTUAL IP ADDRESS>:2480/studio/index.html [OServer] >>> >>> >>> Since our cybersecurity department at my organization frowns upon firing >>> up servers that listen to outward facing ports, I modified the >>> section in config/orientdb-server-config.xml file >>> >>> >>> >> port-range="2424-2430" ip-address="*0.0.0.0*"/> >>> >> port-range="2480-2490" ip-address="*0.0.0.0*"> >>> >>> so that the ip-address field is "127.0.0.1". >>> >>> I can connect Studio to the database using 127.0.0.1:2480 or >>> localhost:2480 and everything works fine. I verified that >>> http://my-machine-name:2480/ will correctly fail too. I hit a problem >>> though when I try to use the console application. >>> >>> I get the following behaviour in console.sh: >>> >>> *$* *console.sh* >>> >>> OrientDB console v.2.2.10 (build >>> 2.2.x@rc32d4ee06d4c38e27eb66931d027eb54854872ff; >>> 2016-09-15 08:47:27+) www.orientdb.com >>> Type 'help' to display all the supported commands. >>> Installing extensions for GREMLIN language v.2.6.0 >>> >>> *orientdb>* connect REMOTE:localhost/myDatabase admin admin >>> >>> Connecting to database [REMOTE:localhost/myDatabase] with user 'admin'... >>> Error: com.orientechnologies.orient.core.exception.OStorageException: >>> Cannot create a connection to remote server address(es): [>> ADDRESS>:2424] >>> DB name="myDatabase" >>> >>> >>> Based on what I can see in the documentation >>> <http://orientdb.com/docs/last/Console-Command-Connect.html> I would >>> think that this should work. I've tried using REMOTE:localhost/myDatabase >>> and REMOTE:127.0.0.1/myDatabase but the result is the same... OrientDB >>> appears to completely ignore my instructions and runs with its default and >>> tries to connect to my machine's real IP address. >>> >>> Is this a bug or is there something that I am missing? >>> >>> -William >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> -- > > --- > 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.
Re: [orientdb] readable query is slow, fast query is un-readable
Have you tried with:
select expand(out().out('ohlc')) from ohlc where asset= #58:2
Best Regards,
Luca Garulli
Founder & CEO
OrientDB LTD <http://orientdb.com/>
Want to share your opinion about OrientDB?
Rate & review us at Gartner's Software Review
<https://www.gartner.com/reviews/survey/home>
On 19 September 2016 at 13:39, hartmut bischoff wrote:
> Hi,
> in a previous mail, I attached a test-database with
>
>- a timegraph 'jahr', 'monat' 'tag'
>- a class 'bar'
>- edges with a property "asset" pointing to a record in a class
>'contract'
>
> There is also some inherence : ohcl<- price <- midpoint, volatility and
> so on.
>
> The Idea is, to define ranges at the timegraph and investigate the
> properties of the connected vertices, which belong to some asset.
>
> This is the basic graph
>
> tag -- (out) -- ohlc -- (in) -- bar
>
> In order to query for all data present for a contract (#58:2),
> My first attempt was a simple direct query:
>
> select expand(out('ohlc')) from tag where out('ohlc).asset = #58:2
>
>
> unfortunately, an empty set was returned
>
> However, changing to
>
> select expand(out('ohlc')) from tag where out_midpoint.asset = #58:2
>
>
> leads to the correct result.
>
> *Question: Is it possible to query inherent edges in this way?*
>
>
> I was very surprised: The query took 0.5 sec, with just a few records in
> the database.
>
> The query took so long, because the hole time-graph was examined, as
> explain revealed: documentReads: 55152
>
> After some thinking, I came out with
>
> select expand(out('ohlc')) from (select expand(out) from ohlc where asset=
>> #58:2 )
>
>
> which fetches an identical result but is almost un-readable. It is 10
> times faster: 0,068 sec.
>
> My question is: I*s it possible to write a human readable query without
> loosing to much performance? *I couldn't figure out a solution using the
> match statement, so maybe there is another solution.
>
> A last thing: How can I determine the effects of scaling in terms of the
> execution time of the query. I wonder, whether my query will be as slow, if
> some hundred contracts and some million bars are present in the database,
> whereas the first attempt has probably a static execution time.
>
> Thanks in advance
>
> hartmut
>
> 10255010010005000
>
> --
>
> ---
> 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.
Re: [orientdb] Re: Performance of Distributed (3 nodes) cluster with one billion edges
On 15 September 2016 at 09:54, Phillip Henry wrote:
> Hi, Luca.
>
Hi Phillip,
3. Yes, default configuration. Apart from adding an index for ACCOUNTS, I
> did nothing further.
>
Ok, so you have writeQuorum="majority" that means 2 sycnhronous writes and
1 asynchronous per transaction.
> 4. Good question. With real data, we expect it to be as you suggest: some
> nodes with the majority of the payments (eg, supermarkets). However, for
> the test data, payments were assigned randomly and, therefore, should be
> uniformly distributed.
>
What's your average in terms of number of edges? <10, <50, <200, <1000?
> 2. Yes, I tried plocal minutes after posting (d'oh!). I saw a good
> improvement. It started about 3 times faster and got faster still (about 10
> times faster) by the time I checked this morning on a job running
> overnight. However, even though it is now running at about 7k transactions
> per second, a billion edges is still going to take about 40 hours. So, I
> ask myself: is there anyway I can make it faster still?
>
Here it's missing the usage of AUTO-SHARDING INDEX. Example:
accountClass.createIndex("Account.number",
OClass.INDEX_TYPE.UNIQUE.toString(), (OProgressListener) null,
(ODocument) null,
"AUTOSHARDING", new String[] { "number" });
In this way you should go more in parallel, because the index is
distributed across all the shards (clusters) of Account class. you should
have 32 of them by default because you have 32 cores.
Please let me know if by sorting the from_accounts and with this change if
it's much faster.
This is the best you can have out of the box. To push numbers up it's
slightly more complicated: you should be sure that transactions go in
parallel and they aren't serialized. This is possible by playing with
internal OrientDB settings (mainly the distributed workerThreads), by
having many clusters per class (You could try with 128 first and see how
it's going).
> I assume when I start the servers up in distributed mode once more, the
> data will then be distributed across all nodes in the cluster?
>
That's right.
> 3. I'll return to concurrent, remote inserts when this job has finished.
> Hopefully, a smaller batch size will mean there is no degradation in
> performance either... FYI: with a somewhat unscientific approach, I was
> polling the server JVM with JStack and saw only a single thread doing all
> the work and it *seemed* to spend a lot of its time in ODirtyManager on
> collection manipulation.
>
I think it's because you didn't use the AUTO-SHARDING index. Furthermore
running distributed, unfortunately, means the tree ridbag is not available
(we will support it in the future), so every change to the edges takes a
lot of CPU to demarshall and marshall the entire edge list everytime you
update a vertex. That's why my recommendation about sorting the vertices.
> I totally appreciate that performance tuning is an empirical science, but
> do you have any opinions as to which would probably be faster:
> single-threaded plocal or multithreaded remote?
>
With v2.2 yo can go in parallel, by using the tips above. For sure the
replication has a cost. I'm sure you can go much faster with just one node
and then start the other 2 nodes to have the database replicated
automatically. At least for the first massive insertion.
>
> Regards,
>
> Phillip
>
Luca
>
> On Wednesday, September 14, 2016 at 3:48:56 PM UTC+1, Phillip Henry wrote:
>>
>> Hi, guys.
>>
>> I'm conducting a proof-of-concept for a large bank (Luca, we had a 'phone
>> conf on August 5...) and I'm trying to bulk insert a humongous amount of
>> data: 1 million vertices and 1 billion edges.
>>
>> Firstly, I'm impressed about how easy it was to configure a cluster.
>> However, the performance of batch inserting is bad (and seems to get
>> considerably worse as I add more data). It starts at about 2k
>> vertices-and-edges per second and deteriorates to about 500/second after
>> only about 3 million edges have been added. This also takes ~ 30 minutes.
>> Needless to say that 1 billion payments (edges) will take over a week at
>> this rate.
>>
>> This is a show-stopper for us.
>>
>> My data model is simply payments between accounts and I store it in one
>> large file. It's just 3 fields and looks like:
>>
>> FROM_ACCOUNT TO_ACCOUNT AMOUNT
>>
>> In the test data I generated, I had 1 million accounts and 1 billion
>> payments randomly distributed between pairs of accounts.
>>
>> I have 2 classes in OrientDB: ACCOUNTS (extending V) and PAYMENT
>> (extending E). There is a UNIQUE_HASH_INDEX on ACCOUNTS for the account
>> number (a string).
>>
>> We're using OrientDB 2.2.7.
>>
>> My batch size is 5k and I am using the "remote" protocol to connect to
>> our cluster.
>>
>> I'm using JDK 8 and my 3 boxes are beefy machines (32 cores each) but
>> without SSDs. I wrote the importing code myself but did nothing 'clever' (I
>> think) and used the Graph API. This client code has been given lots of
>> memory and usi
Re: [orientdb] Console: Exporting query result to CSV file
This is missing in the console, but it's available from Studio. Since I think having this feature in the console makes a lot of sense to me, WDYT about opening a new issue as an enhancement? Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> Want to share your opinion about OrientDB? Rate & review us at Gartner's Software Review <https://www.gartner.com/reviews/survey/home> On 9 September 2016 at 16:14, William wrote: > This is an old thread but it came up pretty high on my google search of > "OrientDB export query result table to CSV" and no examples of this being > done... so I was wondering if anything was ever implemented to allow the > results of a query to be saved into a delimited text file? > > Thanks! > -William > > > On Thursday, October 3, 2013 at 12:06:32 AM UTC-6, Andrey Lomakin wrote: >> >> Not yet, you can create feature request and we will implement it. >> >> >> On Wed, Oct 2, 2013 at 9:30 PM, Sunny Leaves >> wrote: >> >>> Hi, the title says it all: is there a way from the console to save the >>> query result in a CSV file? >>> Something in the flavor of >>> csvwrite(query.csv, select @rid, target, date from myClass) >>> >>> ? >>> >>> -- >>> >>> --- >>> 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-databa...@googlegroups.com. >>> For more options, visit https://groups.google.com/groups/opt_out. >>> >> >> >> >> -- >> Best regards, >> Andrey Lomakin. >> >> Orient Technologies >> the Company behind OrientDB >> >> -- > > --- > 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.
Re: [orientdb] Performance of Distributed (3 nodes) cluster with one billion edges
Hi Phillip, I remember about that call :-) I have a few of questions for you: 1. Are those numbers by running with multiple servers? 2. How many? 3. I guess default configuration, right? 4. How the ACCOUNT vertices are distributed in terms of the number of edges? For example, 90% of the ACCOUNTs have less than 20 PAYMENT edges. Below the first 3 suggestions to run faster, I hope these can be applied to your case. (1) Group creation of edges If you browse the file and you look up or create an ACCOUNT vertex, it means you can have multiple lookups and save of edges as incremental operation. It's much more efficient to *order the file by FROM_ACCOUNT* (you could use the Linux "*sort*" command) and keep open the transaction until the FROM_ACCOUNT changes. In this way, you are avoiding to update the vertices multiple times, but you reduce this operation by grouping the edge creation in the same transaction. In OrientDB transactions consume heap, so unless you have many thousands of elements this is fine, otherwise, you should batch this behavior at blocks of about 5k per transaction. (2) OrientDB Box The first optimization is cutting the *TCP/IP* by *embedding* the database in the same JVM as your application. This is what we call "OrientDB Box". Even if this looks "weird" many users run in this way. Look at http://orientdb.com/orientdb-embedded/. Running embedded allows you to replicate OrientDB across multiple other single servers or other OrientDB boxes. The entire application remains the same, but the URL is *plocal:* instead of *remote:*. You could try it to see how much the network latency between client and server impacts on your numbers. (3) Concurrency If you are using multiple servers as master of your insert, I suggest keeping transaction size much smaller than 5K. You could try with just *16* (your cores/2) and then check by incrementing it. This is because OrientDB distributes the used clusters, but if concurrent distributed transactions work on the same clusters, there will be a lot of waits because of internal locking. Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> Want to share your opinion about OrientDB? Rate & review us at Gartner's Software Review <https://www.gartner.com/reviews/survey/home> On 14 September 2016 at 05:17, Phillip Henry wrote: > Hi, guys. > > I'm conducting a proof-of-concept for a large bank (Luca, we had a 'phone > conf on August 5...) and I'm trying to bulk insert a humongous amount of > data: 1 million vertices and 1 billion edges. > > Firstly, I'm impressed about how easy it was to configure a cluster. > However, the performance of batch inserting is bad (and seems to get > considerably worse as I add more data). It starts at about 2k > vertices-and-edges per second and deteriorates to about 500/second after > only about 3 million edges have been added. This also takes ~ 30 minutes. > Needless to say that 1 billion payments (edges) will take over a week at > this rate. > > This is a show-stopper for us. > > My data model is simply payments between accounts and I store it in one > large file. It's just 3 fields and looks like: > > FROM_ACCOUNT TO_ACCOUNT AMOUNT > > In the test data I generated, I had 1 million accounts and 1 billion > payments randomly distributed between pairs of accounts. > > I have 2 classes in OrientDB: ACCOUNTS (extending V) and PAYMENT > (extending E). There is a UNIQUE_HASH_INDEX on ACCOUNTS for the account > number (a string). > > We're using OrientDB 2.2.7. > > My batch size is 5k and I am using the "remote" protocol to connect to our > cluster. > > I'm using JDK 8 and my 3 boxes are beefy machines (32 cores each) but > without SSDs. I wrote the importing code myself but did nothing 'clever' (I > think) and used the Graph API. This client code has been given lots of > memory and using jstat I can see it is not excessively GCing. > > So, my questions are: > > 1. what kind of performance can I realistically expect and can I improve > what I have at the moment? > > 2. what kind of degradation should I expect as the graph grows? > > Thanks, guys. > > Phillip > > > > -- > > --- > 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.
Re: [orientdb] [Announce]: ActiveOrient 0.5
Hi Hartmut, Thanks for the update! Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> Want to share your opinion about OrientDB? Rate & review us at Gartner's Software Review <https://www.gartner.com/reviews/survey/home> On 1 September 2016 at 04:05, hartmut bischoff wrote: > Hi folks, > > today I released a new Version of ActiveOrient, Access OrientDB using ruby > aka ActiveRecord > > https://github.com/topofocus/active-orient > > There is a small "time-graph" example which describes some features: > > https://github.com/topofocus/active-orient/tree/master/examples/time_graph > > > Summergreetings from Stuttgart > > hartmut > > -- > > --- > 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.
Re: [orientdb] Strategy for loading about 40 GB data to a 3 node OrientDB cluster
Already responded here: http://stackoverflow.com/questions/39169421/strategy-for-loading-data-into-orientdb-cluster/39172827#39172827 Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> Want to share your opinion about OrientDB? Rate & review us at Gartner's Software Review <https://www.gartner.com/reviews/survey/home> On 26 August 2016 at 10:05, wrote: > I'm in the process of working on a POC with OrientDB. I've set it up > across 3 servers. I read the OrientDB documentation and wanted to > know the best possible method to load the data which is in the form of CSV > files. The schema having 3 class vertices and 3 class edges which should be > interconnected among one another. > > Below are some of the questions i have : > > 1) Does it make sense in terms of ETL performance, if i create 3 clusters > for each of the classes and assign each cluster to one of the servers ? ( > based on this link : http://orientdb.com/docs/2. > 2.x/Distributed-Sharding.html I'm not worried about fault tolerance at > this stage ) > > 2) Regarding the ETL storage process, i'm considering 3 options : > >- The ETL tool provided with OrientDB ( with all possible >optimizations ) >- Utilizing OGraphBatchInsert >- Storing in terms of document ( http://orientdb.com/docs/2. >2.x/Graph-Batch-Insert.html ) > > For the 2nd and 3rd method, I'm required to provide Record Ids manually, > My doubt is how do i make sure Duplicate vertices are not created. Will > Indexing help avoid this ? > How does the above 3 methods compare in terms of performance ? > > 3) Is it possible to store in one server of the OrientDB cluster within > that machine using the "plocal" option in the ETL tool ? > > 4) Is it possible to use plocal option for ETL , even when the OrientDB > runs on distributed mode ? > > > -- > > --- > 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.
Re: [orientdb] Re: documentation inconstistency
I've just updated the documentation with 2 more examples ;-) Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> Want to share your opinion about OrientDB? Rate & review us at Gartner's Software Review <https://www.gartner.com/reviews/survey/home> On 26 August 2016 at 03:36, odbuser wrote: > I think the documentation is currently misleading but not wrong. > > When you know the rid of the edge, the simplest syntax is: > DELETE EDGE #11:0 > > But the following two statements will also work: > DELETE EDGE WHERE @rid IN (SELECT FROM #11:0) > DELETE EDGE E WHERE @rid IN (SELECT FROM #11:0) > > And the following will not b/c it's the record reference in the FROM > should be a vertex not an edge: > DELETE EDGE FROM (SELECT FROM #11:0) > Cannot retrieve a vertex with the RID #11:0 because it is an edge > > But the documentation on http://orientdb.com/docs/maste > r/SQL-Delete-Edge.html > <http://www.google.com/url?q=http%3A%2F%2Forientdb.com%2Fdocs%2Fmaster%2FSQL-Delete-Edge.html&sa=D&sntz=1&usg=AFQjCNF3Mc8LaosRTemLH3wZwujmk2V7zw> > is referring to subqueries so the example may not be the best to illustrate > the point. > > In any case, I suggest that you open an issue in the git documentation > project: > https://github.com/orientechnologies/orientdb-docs/issues > and make sure you mention the version of OrientDB that you are using, > reference the link to the documentation, what it says, and what you think > it should say. > > > > > > > On Friday, August 26, 2016 at 2:26:41 AM UTC-4, hartmut bischoff wrote: >> >> http://orientdb.com/docs/master/SQL-Delete-Edge.html >> >> Deleting Edges from a Sub-query >> >> Consider a situation where you have an edge with a Record ID of #11:0 >> that you want to delete. In attempting to do so, you run the following >> query: >> >> orientdb> DELETE EDGE FROM (SELECT FROM #11:0) >> (...) >> >> >> Syntax >> >> DELETE EDGE >> ( >> | >> [ (, )*] >> (...) >> >> >> If I want to delete the Edge #11:0, I run >> DELETE EDGE #11:0 >> >> >> The documentation tells me to use >> DELETE EDGE E WHERE @rid IN (SELECT FROM #11:0) >> instead >> >> >> -- > > --- > 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.
Re: [orientdb] Indexing and Queries with Java API
Cool you solved.
Anyway we have to improve the docs, because I'm sure many users just drop
OrientDB after the first problem and maybe it's something trivial like this
;-)
Best Regards,
Luca Garulli
Founder & CEO
OrientDB LTD <http://orientdb.com/>
Want to share your opinion about OrientDB?
Rate & review us at Gartner's Software Review
<https://www.gartner.com/reviews/survey/home>
On 18 August 2016 at 15:29, John J. Szucs wrote:
> New issue opened at https://github.com/orientechnologies/orientdb/
> issues/6589.
>
> BTW, the performance test results I shared yesterday where running under
> the debugger and with extensive instrumentation. Here are the "clean"
> results. Wow!
>
> Created 1 entities in 00:00:05.840, 1712.33 per second
> Retrieving 1 entities...
> Retrieved 1 entities in 00:00:01.561, 6406.15 per second
> Deleting 1 entities...
> Deleted 1 entities in 00:00:01.960, 5102.04 per second
>
> Thanks again!
>
> -- John
>
> On Wednesday, August 17, 2016 at 11:55:51 PM UTC-4, l.garulli wrote:
>>
>> Hi John,
>>
>> Happy to help. Yes, please, could you open a new issue for the
>> documentation?
>>
>> Best Regards,
>>
>> Luca Garulli
>> Founder & CEO
>> OrientDB LTD <http://orientdb.com/>
>>
>> Want to share your opinion about OrientDB?
>> Rate & review us at Gartner's Software Review
>> <https://www.gartner.com/reviews/survey/home>
>>
>>
>> On 17 August 2016 at 07:45, John J. Szucs wrote:
>>
>>> Luca,
>>>
>>> I just tried this. The only change was:
>>>
>>> Iterable vertices=graph.getVertices("identifier", myUriStr);
>>>
>>> to:
>>>
>>> Iterable vertices=graph.getVertices("Identifier.identifier",
>>> myUriStr);
>>>
>>>
>>> The results speak for themselves:
>>>
>>> Created 1 entities in 00:02:05.755, 79.52 per second
>>>
>>>
>>> This is the kind of performance I was expecting!
>>>
>>> Thank you!!!
>>>
>>> I will note that this was a very subtle change. Essentially, it seems
>>> that for the graph API's getVertices() method to use the indices, the
>>> property names have to be qualified with the vertex type name. Would you
>>> like for me to add an issue on GitHub to improve the documentation around
>>> this?
>>>
>>> Thanks again!
>>>
>>> -- John
>>>
>>> On Tuesday, August 16, 2016 at 7:01:10 PM UTC-4, l.garulli wrote:
>>>>
>>>> It looks like you're not using the index from the Graph API. Look at
>>>> the documentation:
>>>>
>>>> http://orientdb.com/docs/last/Performance-Tuning-Graph.html#
>>>> use-indexes-to-lookup-vertices-by-an-id
>>>>
>>>> If it's not clear, please write here again, we will help you on this ;-)
>>>>
>>>> Best Regards,
>>>>
>>>> Luca Garulli
>>>> Founder & CEO
>>>> OrientDB LTD <http://orientdb.com/>
>>>>
>>>> Want to share your opinion about OrientDB?
>>>> Rate & review us at Gartner's Software Review
>>>> <https://www.gartner.com/reviews/survey/home>
>>>>
>>>>
>>>> On 16 August 2016 at 17:26, John J. Szucs wrote:
>>>>
>>>>> In my OrientDB-based application, I need to do an INSERT-IF-NOT-EXISTS
>>>>> operation using the Java (TinkerPop) API.
>>>>>
>>>>> I have created a vertex type "Identifier." It has a single property,
>>>>> "identifier," which contains a URI (effectively a String for purposes of
>>>>> this discussion).
>>>>>
>>>>> I have also created an index like this:
>>>>>
>>>>> ParametersBuilder builder=new ParametersBuilder();
>>>>>
>>>>> builder.add("class", "Identifier");
>>>>>
>>>>> builder.add("type", "UNIQUE_HASH_INDEX");
>>>>>
>>>>> graph.createKeyIndex("identifier", Vertex.class, builder.build());
>>>>>
>>>>>
>>>>> Then, I perform the INSERT-IF-NOT-EXISTS operation in a loop like
>>>>> this. This snippet is using the Google Guava libraries and is obviously a
>>>>> simplification of our real application:
>>>>>
&g
Re: [orientdb] Indexing and Queries with Java API
Hi John,
Happy to help. Yes, please, could you open a new issue for the
documentation?
Best Regards,
Luca Garulli
Founder & CEO
OrientDB LTD <http://orientdb.com/>
Want to share your opinion about OrientDB?
Rate & review us at Gartner's Software Review
<https://www.gartner.com/reviews/survey/home>
On 17 August 2016 at 07:45, John J. Szucs wrote:
> Luca,
>
> I just tried this. The only change was:
>
> Iterable vertices=graph.getVertices("identifier", myUriStr);
>
> to:
>
> Iterable vertices=graph.getVertices("Identifier.identifier",
> myUriStr);
>
>
> The results speak for themselves:
>
> Created 1 entities in 00:02:05.755, 79.52 per second
>
>
> This is the kind of performance I was expecting!
>
> Thank you!!!
>
> I will note that this was a very subtle change. Essentially, it seems that
> for the graph API's getVertices() method to use the indices, the property
> names have to be qualified with the vertex type name. Would you like for me
> to add an issue on GitHub to improve the documentation around this?
>
> Thanks again!
>
> -- John
>
> On Tuesday, August 16, 2016 at 7:01:10 PM UTC-4, l.garulli wrote:
>>
>> It looks like you're not using the index from the Graph API. Look at the
>> documentation:
>>
>> http://orientdb.com/docs/last/Performance-Tuning-Graph.html#
>> use-indexes-to-lookup-vertices-by-an-id
>>
>> If it's not clear, please write here again, we will help you on this ;-)
>>
>> Best Regards,
>>
>> Luca Garulli
>> Founder & CEO
>> OrientDB LTD <http://orientdb.com/>
>>
>> Want to share your opinion about OrientDB?
>> Rate & review us at Gartner's Software Review
>> <https://www.gartner.com/reviews/survey/home>
>>
>>
>> On 16 August 2016 at 17:26, John J. Szucs wrote:
>>
>>> In my OrientDB-based application, I need to do an INSERT-IF-NOT-EXISTS
>>> operation using the Java (TinkerPop) API.
>>>
>>> I have created a vertex type "Identifier." It has a single property,
>>> "identifier," which contains a URI (effectively a String for purposes of
>>> this discussion).
>>>
>>> I have also created an index like this:
>>>
>>> ParametersBuilder builder=new ParametersBuilder();
>>>
>>> builder.add("class", "Identifier");
>>>
>>> builder.add("type", "UNIQUE_HASH_INDEX");
>>>
>>> graph.createKeyIndex("identifier", Vertex.class, builder.build());
>>>
>>>
>>> Then, I perform the INSERT-IF-NOT-EXISTS operation in a loop like this.
>>> This snippet is using the Google Guava libraries and is obviously a
>>> simplification of our real application:
>>>
>>> int n=1;
>>> for (int i=0; i>> {
>>>
>>> String myUriStr="http://example.org/"+i.toString();
>>>
>>> Iterable vertices=graph.getVertices("identifier", myUriStr);
>>>
>>> Vertex vertex=Iterables.getOnlyElement(vertices);
>>>
>>> if (null==vertex)
>>>
>>> {
>>>
>>> // Create vertex
>>>
>>> ...
>>>
>>> }
>>>
>>> // Use vertex
>>>
>>> ...
>>>
>>> }
>>>
>>>
>>> What I am seeing is that the throughput of this loop rapidly diminishes
>>> as more vertices are added, like this (with the throughput relative to the
>>> n=1,000 baseline):
>>>
>>>
>>> n=1,000 throughput=100%
>>> n=2,000 throughput=58.8%
>>> n=5,000 throughput=29.7%
>>>
>>> n=10,000 throughput=16.5%
>>>
>>>
>>> This obviously suggests that indexing is not working, so I tried a SQL
>>> EXPLAIN command.
>>>
>>> *explain select from identifier where identifier='http://example.org/1
>>> <http://example.org/1>'*
>>> documentReads=1
>>> fullySortedByIndex=false
>>> documentAnalyzedCompatibleClass=1
>>> recordReads=1
>>> fetchingFromTargetElapsed=0
>>> indexIsUsedInOrderBy=false
>>> compositeIndexUsed=1
>>> current=Identifier#153:0{identifier:http://example.org/1,out_id:[size=1]}
>>> v2
>>> involvedIndexes=[Identifier.identifier]
>>> limit=-1
>>> evaluated=1
>>> user=#5:0
>>> elapsed=2.387001
>>> resultType=collection
>>> resultSize=1
>>>
>>>
>
Re: [orientdb] Indexing and Queries with Java API
It looks like you're not using the index from the Graph API. Look at the
documentation:
http://orientdb.com/docs/last/Performance-Tuning-Graph.html#use-indexes-to-lookup-vertices-by-an-id
If it's not clear, please write here again, we will help you on this ;-)
Best Regards,
Luca Garulli
Founder & CEO
OrientDB LTD <http://orientdb.com/>
Want to share your opinion about OrientDB?
Rate & review us at Gartner's Software Review
<https://www.gartner.com/reviews/survey/home>
On 16 August 2016 at 17:26, John J. Szucs wrote:
> In my OrientDB-based application, I need to do an INSERT-IF-NOT-EXISTS
> operation using the Java (TinkerPop) API.
>
> I have created a vertex type "Identifier." It has a single property,
> "identifier," which contains a URI (effectively a String for purposes of
> this discussion).
>
> I have also created an index like this:
>
> ParametersBuilder builder=new ParametersBuilder();
>
> builder.add("class", "Identifier");
>
> builder.add("type", "UNIQUE_HASH_INDEX");
>
> graph.createKeyIndex("identifier", Vertex.class, builder.build());
>
>
> Then, I perform the INSERT-IF-NOT-EXISTS operation in a loop like this.
> This snippet is using the Google Guava libraries and is obviously a
> simplification of our real application:
>
> int n=1;
> for (int i=0; i {
>
> String myUriStr="http://example.org/"+i.toString();
>
> Iterable vertices=graph.getVertices("identifier", myUriStr);
>
> Vertex vertex=Iterables.getOnlyElement(vertices);
>
> if (null==vertex)
>
> {
>
> // Create vertex
>
> ...
>
> }
>
> // Use vertex
>
> ...
>
> }
>
>
> What I am seeing is that the throughput of this loop rapidly diminishes as
> more vertices are added, like this (with the throughput relative to the
> n=1,000 baseline):
>
>
> n=1,000 throughput=100%
> n=2,000 throughput=58.8%
> n=5,000 throughput=29.7%
>
> n=10,000 throughput=16.5%
>
>
> This obviously suggests that indexing is not working, so I tried a SQL
> EXPLAIN command.
>
> *explain select from identifier where identifier='http://example.org/1
> <http://example.org/1>'*
> documentReads=1
> fullySortedByIndex=false
> documentAnalyzedCompatibleClass=1
> recordReads=1
> fetchingFromTargetElapsed=0
> indexIsUsedInOrderBy=false
> compositeIndexUsed=1
> current=Identifier#153:0{identifier:http://example.org/1,out_id:[size=1]}
> v2
> involvedIndexes=[Identifier.identifier]
> limit=-1
> evaluated=1
> user=#5:0
> elapsed=2.387001
> resultType=collection
> resultSize=1
>
>
> The documentation at http://orientdb.com/docs/master/SQL-Explain.html does
> not seem to be 100% current on how to interpret the output of the EXPLAIN
> command, but my interpretation is that the query did recognize and use the
> index that I created.
>
> I also tried some profiling (with JProfiler) and see a hot spot
> at com.tinkerpop.blueprints.impls.orient.OrientElementIterator.hasNext.
>
> All of this is with OrientDB running in embedded mode, on a fairly
> high-end Linux machine and with a fresh, empty database at the beginning of
> each test.
>
> I have to believe I am doing something wrong to see such a rapid drop-off
> in query performance under such relatively small data volumes.
>
> I have been struggling with this for several days off-and-on now and it's
> time to ask for help. Has anyone else encountered a similar issue? What can
> I do to address this?
>
> Thanks in advance!
>
> -- John
>
> --
>
> ---
> 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.
Re: [orientdb] Re: How to sync OrientDB data in Elastic for searching purpose?
Hi, I've just published this plugin we used a couple of time to display OrientDB data on Kibana: https://github.com/orientechnologies/orientdb-elasticsearch Sorry, it's in alpha and there is no even the README file. Anyway you can compile it and put the jar under the server libs. Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> Want to share your opinion about OrientDB? Rate & review us at Gartner's Software Review <https://www.gartner.com/reviews/survey/home> On 12 August 2016 at 01:33, Suyog Kale wrote: > can I use live queries using nodejs? is it recommended ? > > > On Friday, 12 August 2016 11:58:55 UTC+5:30, Suyog Kale wrote: >> >> Does it works with NodeJS? >> >> >> On Friday, 12 August 2016 11:03:24 UTC+5:30, Ivan Mainetti wrote: >>> >>> http://orientdb.com/docs/last/Hook.html >>> >>> >>> Il giorno venerdì 12 agosto 2016 06:11:27 UTC+2, Suyog Kale ha scritto: >>>> >>>> Hello, >>>> >>>> I want sync OrientDb data in ElasticSearch DB, does OrientDB support >>>> any triggers on data Insert,update,delete ? if yes please share me >>>> reference link. In case of MongoDB it provides oplogs which can be used to >>>> sync changed document into another database. >>>> >>>> I am using NodeJS, so I want there are any support npm pacakges that >>>> works with OrientDB to fire such triggers. >>>> >>>> Regards, >>>> Suyog >>>> >>>> -- > > --- > 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.
[orientdb] Sustain the OrientDB Project
Is your application powered by the OrientDB technology? OrientDB Community Edition is *FREE* for any usage (Apache2 license) and today it's running with thousands of applications around the world. How can you help the OrientDB Project? In at least 4 ways: 1. With Pull Requests for *bug fixing*, *enhancements*, *tests* and also *typos* in documentation 2. By improving the existent *documentation* (Click on "Edit Page" and send us a Pull Request about the update page), specially providing more *examples* 3. By telling us *how you are using* OrientDB in your application About (3) I'd like to know more about your use case and if it could be interesting for other users we could write a *Case Study* together. The Case Study will help other developers to understand if OrientDB can be the right choice for their project. The best way to sustain the OrientDB project, in the Open Source spirit, is by giving something back with one of the four things mentioned above. Thanks in advance for supporting OrientDB! Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> Want to share your opinion about OrientDB? Rate & review us at Gartner's Software Review <https://www.gartner.com/reviews/survey/home> -- --- 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.
Re: [orientdb] Edge property name convention change
Hi,
Nothing is changed about that. Did you set
graph.setUseClassForEdgeLabel(false) in your application?
Best Regards,
Luca Garulli
Founder & CEO
OrientDB LTD <http://orientdb.com/>
Want to share your opinion about OrientDB?
Rate & review us at Gartner's Software Review
<https://www.gartner.com/reviews/survey/home>
On 30 July 2016 at 13:31, odbuser wrote:
>
> When did the edge name convention change? Can you point me to the issue
> that caused this convention change? I may be totally off base and maybe
> this was actually changed in 2.2.0 vs 2.1.0 but if it was changed say 2.2.6
> vs. 2.2.4, then it seems like an invasive change for a point release.
>
> It used to be:
> {someEdgeClass}.in_{someEdgeClass}
> {someEdgeClass}.out_{someEdgeClass}
>
> But is now (in 2.2.6 at least)
> {someEdgeClass}.in
> {someEdgeClass}.out
>
>
> create class A extends V
> create class B extends V
> create class EAB extends E
>
> --OLD WAY
> --CREATE PROPERTY EAB.out_EAB LINK
> --NEW WAY
> CREATE PROPERTY EAB.out LINK
>
> --OLD WAY
> --CREATE PROPERTY EAB.in_EAB LINK
> --NEW WAY
> CREATE PROPERTY EAB.in LINK
>
> --OLD WAY
> --CREATE INDEX EAB.key on EAB (out_EAB,in_EAB) unique
> --NEW WAY
> CREATE INDEX EAB.key on EAB (out,in) unique;
>
> create vertex A;
> create vertex A;
> create vertex B;
>
> --The following would fail with the old naming convention
> --But succeed with the new naming convention
> create edge EAB from (select from A) to (select from B)
>
>
> --
>
> ---
> 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.
Re: [orientdb] OrientDB. Setting ConflictStrategy throwing an exception
Already answered on Stack Overflow:
http://stackoverflow.com/questions/38650067/orientdb-setting-conflictstrategy-throwing-an-exception/38651248#38651248
Best Regards,
Luca Garulli
Founder & CEO
OrientDB LTD <http://orientdb.com/>
Want to share your opinion about OrientDB?
Rate & review us at Gartner's Software Review
<https://www.gartner.com/reviews/survey/home>
On 29 July 2016 at 00:10, Mikayel Nersisyan wrote:
> I have OObjectDatabaseTx. I want to set my own conflict strategy using api.
>
> OObjectDatabaseTx db;
> db.setConflictStrategy(new ORecordConflictStrategy() {
> @Override
> public byte[] onUpdate(OStorage storage, byte iRecordType,
> ORecordId rid, ORecordVersion iRecordVersion, byte[] iRecordContent,
> ORecordVersion iDatabaseVersion) {
> ;
> }
>
> @Override
> public String getName() {
> return "SOME NAME";
> }
> });
>
> On execution i'm getting an exception sarying that operation is not
> supported.
>
> 10:40:48,718 INFO
> [com.ats.vis.services.transaction.TransactionManager]
> (TransactionExecutor[UML]) [__MAIN_WS__] ERROR::
> java.lang.UnsupportedOperationException: setConflictStrategy
> at
> com.orientechnologies.orient.client.remote.OStorageRemoteThread.setConflictStrategy(OStorageRemoteThread.java:318)
> [orientdb-client-2.1.19.jar:2.1.19]
> at
> com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx.setConflictStrategy(ODatabaseDocumentTx.java:1122)
> [orientdb-core-2.1.19.jar:2.1.19]
> at
> com.orientechnologies.orient.object.db.OObjectDatabaseTx.setConflictStrategy(OObjectDatabaseTx.java:760)
> [orientdb-object-2.1.19.jar:2.1.19]
>
> Is there any way to set conflict strategy?
>
> --
>
> ---
> 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.
Re: [orientdb] Re: alter database CLUSTERSELECTION round-robin generates an error in version 2.2.5
I think there is an error in the new SQL parser. Luigi? Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> On 25 July 2016 at 22:10, wrote: > Ok, but when you create a new db the cluster selection as already set to > round - robin so why did you try to execute that command? > > Regards, > Michela > > -- > > --- > 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.
Re: [orientdb] tests on OrientDB are failing
Hi Shiva, Sure we need more information, here you don't say anything. Which version? What's your configuration? Where is the thread dump? Etc. Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> On 25 July 2016 at 05:35, Kumar shiva wrote: > HI , > > Our tests started failing as we started to increase number of concurrent > connections. > > We have taken Heapdump Snapshots taken using VisualVM . > > Please let me know the further information required. > > regards > > Shiva > > -- > > --- > 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.
Re: [orientdb] Re: "Pinning" a table in memory
@Eric, doesn't help, it was funny that we had this feature with the old LOCAL storage engine. Anyway, even if implementing this should be quite trivial, Andrey could have a better idea about how to do that. Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> On 21 July 2016 at 09:56, Eric Lenington wrote: > @Luca: How does it help that it used to exist in LOCAL storage? What I'm > looking for is a class in PLOCAL that works in every way the same as any > other class (specifically including replication), but is guaranteed to be > 100% in memory and has the option of being persisted to disk or not. > --Eric > > > On Wed, Jul 20, 2016 at 11:24 AM, Luca Garulli > wrote: > >> Funny thing: this feature was already existent with the old LOCAL storage >> :-) >> >> Best Regards, >> >> Luca Garulli >> Founder & CEO >> OrientDB LTD <http://orientdb.com/> >> >> >> On 20 July 2016 at 09:41, 'scott molinari' via OrientDB < >> orient-database@googlegroups.com> wrote: >> >>> Hey Eric. Already done! >>> >>> https://github.com/orientechnologies/orientdb/issues/6447 >>> >>> Hope you don't mind. >>> >>> Scott >>> >>> -- >>> >>> --- >>> 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 a topic in the >> Google Groups "OrientDB" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/orient-database/_xwbdw55_IM/unsubscribe >> . >> To unsubscribe from this group and all its topics, 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. > -- --- 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.
Re: [orientdb] Re: OrientDB News: Parallel Transactions
Once the class is created, the cluster are created under the hood, so no matter if you copy the database on a Raspberry PI device: the cluster count is done and they never change unless you add new clusters manually. About the version it's 2.2.5 and not 2.2.4, sorry for the typo. Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> On 21 July 2016 at 01:40, 'scott molinari' via OrientDB < orient-database@googlegroups.com> wrote: > In the world of VMs and IaaS, I don't think putting up exact nodes should > be an issue. > > However, what happens, if a class created with 8 clusters, is moved to a > new VM with more cores? Is the class then stuck on 8 clusters? Or can ODB > create and redistribute the data into any new clusters automatically? > > Scott > > -- > > --- > 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.
Re: [orientdb] Re: OrientDB News: Parallel Transactions
In order to run fast and use the parallelism yes. But you can still have different machines with 4-8-16 cores, but the machine with less core could be the bottleneck. Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> On 21 July 2016 at 00:22, 'scott molinari' via OrientDB < orient-database@googlegroups.com> wrote: > Does this mean the machines running in a distributed cluster will all need > to be the same in terms of cores for ODB to work right and fast? > > Scott > > -- > > --- > 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.
Re: [orientdb] Re: "Pinning" a table in memory
Funny thing: this feature was already existent with the old LOCAL storage :-) Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> On 20 July 2016 at 09:41, 'scott molinari' via OrientDB < orient-database@googlegroups.com> wrote: > Hey Eric. Already done! > > https://github.com/orientechnologies/orientdb/issues/6447 > > Hope you don't mind. > > Scott > > -- > > --- > 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.
[orientdb] OrientDB EE supports Data Center configuration
Starting from OrientDB Enterprise Edition v2.2.4, you can define how your
servers are deployed in multiple Data Centers. All you need is using the
tag "dataCenters" in your default-distributed-config.json configuration
file. This is the format:
"dataCenters": {
"": {
"writeQuorum": "",
"servers": [ "", "",
"" ]
},
"": {
"writeQuorum": "",
"servers": [ "", "",
"" ]
},
},
NOTE: This feature is available only in the OrientDB Enterprise Edition. If
you are interested in a commercial license look at OrientDB Subscription
Packages <http://orientdb.com/support/>.
*Write Quorum*
The most common reason why defining data centers is a good idea is the
possibility of defining the consistency at data center level. A typical
scenario is having a synchronous replication between the servers in the
same data center where the coordinator server is located and then propagate
changes to the other data centers in asynchronous way. In this way you can
avoid the cost of the latency of the replication to the servers located on
different data centers. In order to activate this mode, set the
global"writeQuorum": "localDataCenter" and then specify a writeQuorum per
data center.
For example, if a write operation is executed by a server where its data
center's write quorum setting ismajority, then the used quorum will be
majority between only the servers located in the same data center.
Example about the configuration of 2 data centers, "rome" and "austin",
with rispectively 3 and 2 servers.
{
"autoDeploy": true,
"readQuorum": 1,
"writeQuorum": "localDataCenter",
"readYourWrites": true,
"dataCenters": {
"rome": {
"writeQuorum": "majority",
"servers": [ "europe-0", "europe-1", "europe-2" ]
},
"austin": {
"writeQuorum": "majority",
"servers": [ "usa-0", "usa-1" ]
}
},
"servers": { "*": "master" },
"clusters": {
"internal": {},
"*": { "servers": [ "" ] }
}
}
If a write operation is executed on the server "europe-0", the quorum used
will be majority, but only between the servers locates in the same data
center: namely "europe-0" (the coordinator), "europe-1" and "europe-2".
Since the coordinator writes in the database before to distribute the
operation, the write operation succeed as soon as at least one between the
"europe-1" and "europe-2" servers provide the same result as with
"europe-0". The rest of the replication will be executed in background in
asycnhronous way.
*Consistency*
Since multiple data centers can have a local quorum, it is possible having
an Eventual Consistencybetween them. It's always suggested to keep the
number of servers odd, so you can, eventually, always be consistent.
Example of 2 data centers with equal number of servers:
"dataCenters": {
"rome": {
"writeQuorum": "all",
"servers": [ "europe-0", "europe-1", "europe-2" ]
},
"austin": {
"writeQuorum": "all",
"servers": [ "usa-0", "usa-1", "usa-2" ]
}
In this case if an UPDATE operation is executed by the server "usa-0" (the
coordinator), it will reach the quorum only if all the servers in the
"austin" data center provide the same result. Let's say the result for all
these 2 servers was 5 (in the UPDATE operation the result is the updated
version of the record). But what happens if all the other 3 servers in
"rome" return the version 6? You have no majority in this case (3 against
3), so the coordinator cannot establish who is the winner. The database
become inconsistent.
In order to automatically manage conflicts, the suggested configuration is
always to keep an odd number of servers if you have or not data centers.
*Conflict Resolution Policy*
In case of even number of servers, a Conflict Resolution Policy has to be
defined. This is not yet available, but it's in our roadmap.
Any question/comment/idea/improvement on this?
Best Regards,
Luca Garulli
Founder & CEO
OrientDB LTD <http://orientdb.com/>
--
---
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.
[orientdb] OrientDB News: Parallel Transactions
Hi guys, This email is to keep you posted about the news on the development of OrientDB. Starting from v2.2.4 we introduced *parallel transaction*. Before v2.2.4, transactions acquire an exclusive lock on the storage, so no matter if you have 1 or 100 cores, the execution was serialized. Now transactions are executed in parallel only if they involve different clusters (files). So, having 16 cores, you could set ALTER DATABASE MINIMUMCLUSTERS 16, so all the classes that you create after this command will have 16 clusters (files) per class. Now, if you have 16 threads, or 16 clients (if you are working with remote protocol and any non Java/Scala driver) you could bind the thread/client to a cluster id. Example: Client 1: BEGIN LET v1 = CREATE VERTEX V CLUSTER v_1 SET name = 'Luca' LET v2 = CREATE VERTEX V CLUSTER v_1 SET name = 'Austin' CREATE EDGE e CLUSTER e_1 FROM $v1 TO $v2 COMMIT RETRY 10 Client 2: BEGIN LET v1 = CREATE VERTEX V CLUSTER v_2 SET name = 'Luca' LET v2 = CREATE VERTEX V CLUSTER v_2 SET name = 'Austin' CREATE EDGE e CLUSTER e_2 FROM $v1 TO $v2 COMMIT RETRY 10 In this case the 2 transactions go in parallel, because they work on different clusters: _1 for the 1st client and _2 for the 2nd. If you have experienced poor performance with transaction, it's time to sue this powerful enhancement! Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> -- --- 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.
Re: [orientdb] orientdb embedded server in .Net
I remember somebody did it by using http://www.ikvm.net/ and it worked perfectly. Maybe you can try it. Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> On 19 July 2016 at 08:18, Roberto Franchini wrote: > On Tue, Jul 19, 2016 at 10:06 AM, Shoham Ben-Har > wrote: > > Hello, > > > > Is it possible to embed orientDB server in a .net application? > > > > OrientDB is written in Java, so it easily embeddable in any jvm-based > language. > > So, no, it's impossible to embed in .NET. > > The .net driver is under development: > > http://orientdb.com/innov8tive-orientdb/ > > https://github.com/Innov8tiveSoftware/OrientDB-NET.binary > > > > -- > Best regards, > > Roberto Franchini > > OrientDB LTD - http://orientdb.com > > -- > > --- > 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.
Re: [orientdb] Using math.js in Functions
You're right, just added this example: https://github.com/orientechnologies/orientdb-docs/blob/master/Functions-Use.md#call-functions-via-sql It will go to the official documentation in the next hours. Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> On 12 July 2016 at 12:50, Tore wrote: > Indeed. I misread another thread. May be an explicit example should be > included in the docs? > Thanks again. > > On Tuesday, July 12, 2016 at 3:03:09 PM UTC+2, l.garulli wrote: >> >> Hi Tore, >> >> Sure you can call any function from SQL. >> >> Best Regards, >> >> Luca Garulli >> Founder & CEO >> OrientDB LTD <http://orientdb.com/> >> >> >> On 12 July 2016 at 06:24, Tore wrote: >> >>> Thanks Luca. >>> Still, the question is really about using a function written in >>> Studio/Functions. Lets assume I write a javascript >>> function in Studio called snug(p), with one parameter. Can I use this in >>> a select statement, e.g. select snug(Sfactor) from Foo... >>> Saw some discussion about that somewhere. Can this be done? >>> >>> On Tuesday, July 12, 2016 at 4:03:09 AM UTC+2, l.garulli wrote: >>>> >>>> You can use the Java math for sure: >>>> https://docs.oracle.com/javase/8/docs/api/java/lang/Math.html >>>> >>>> Example: >>>> >>>> var value = java.lang.Math.abs( v ); >>>> >>>> >>>> >>>> Best Regards, >>>> >>>> Luca Garulli >>>> Founder & CEO >>>> OrientDB LTD <http://orientdb.com/> >>>> >>>> >>>> On 11 July 2016 at 14:09, Tore wrote: >>>> >>>>> Trying to utilize math() in a function (javascript). >>>>> If this can be done, is there a way to use a function in a query? >>>>> e.g. select math.asinh(XXX) as yyy from ... >>>>> >>>>> -- >>>>> >>>>> --- >>>>> 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-databa...@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-databa...@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. > -- --- 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.
Re: [orientdb] Using math.js in Functions
Hi Tore, Sure you can call any function from SQL. Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> On 12 July 2016 at 06:24, Tore wrote: > Thanks Luca. > Still, the question is really about using a function written in > Studio/Functions. Lets assume I write a javascript > function in Studio called snug(p), with one parameter. Can I use this in a > select statement, e.g. select snug(Sfactor) from Foo... > Saw some discussion about that somewhere. Can this be done? > > On Tuesday, July 12, 2016 at 4:03:09 AM UTC+2, l.garulli wrote: >> >> You can use the Java math for sure: >> https://docs.oracle.com/javase/8/docs/api/java/lang/Math.html >> >> Example: >> >> var value = java.lang.Math.abs( v ); >> >> >> >> Best Regards, >> >> Luca Garulli >> Founder & CEO >> OrientDB LTD <http://orientdb.com/> >> >> >> On 11 July 2016 at 14:09, Tore wrote: >> >>> Trying to utilize math() in a function (javascript). >>> If this can be done, is there a way to use a function in a query? >>> e.g. select math.asinh(XXX) as yyy from ... >>> >>> -- >>> >>> --- >>> 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-databa...@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. > -- --- 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.
Re: [orientdb] Using math.js in Functions
You can use the Java math for sure: https://docs.oracle.com/javase/8/docs/api/java/lang/Math.html Example: var value = java.lang.Math.abs( v ); Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> On 11 July 2016 at 14:09, Tore wrote: > Trying to utilize math() in a function (javascript). > If this can be done, is there a way to use a function in a query? > e.g. select math.asinh(XXX) as yyy from ... > > -- > > --- > 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.
Re: [orientdb] Re: File is locked by another proce
The last GA.
Best Regards,
Luca Garulli
Founder & CEO
OrientDB LTD <http://orientdb.com/>
On 8 July 2016 at 08:50, Pugazharasan Thirumalai
wrote:
> Can you please suggest which version may i use?
>
> On Friday, July 8, 2016 at 4:06:55 PM UTC+5:30, Andrey Lomakin wrote:
>>
>> I think that if you send me DB I may fix this.
>> But in general I strongly suggest do not use 2.0.x version , it is
>> officially not supported anymore and has few critical issues which are
>> already fixed in other branches.
>>
>> On Fri, Jul 8, 2016 at 11:12 AM Pugazharasan Thirumalai <
>> pugazh...@gmail.com> wrote:
>>
>>> Now that error is not coming but now am getting the new error as,
>>>>
>>>>
>>> WARNING {db=ces} segment file 'database.ocf' was not closed correctly
>>> last time [OSingleFileSegment]
>>> 2016-07-08 13:39:20:237 SEVERE {db=ces} Internal server error:
>>> com.orientechnologies.orient.core.exception.OStorageException: Cannot
>>> open local storage
>>> '/home/gms/orientdb/orientdb-community-2.0.18/databases/ces' with mode=rw
>>> --> com.orientechnologies.orient.core.exception.OStorageException: File
>>> 'index.pcl' is not registered in 'file name - id' map, but exists in file
>>> system [ONetworkProtocolHttpDb]
>>>
>>>
>>> Thanks and Regards,
>>> T.Pugazharasan
>>>
>>> --
>>>
>>> ---
>>> 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-databa...@googlegroups.com.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>> --
>> Best regards,
>> Andrey Lomakin, R&D lead.
>> OrientDB Ltd
>>
>> twitter: @Andrey_Lomakin
>> linkedin: https://ua.linkedin.com/in/andreylomakin
>> blogger: http://andreylomakin.blogspot.com/
>>
> --
>
> ---
> 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.
Re: [orientdb] All those extra clusters in v2.2
Absolutely, because the setting is saved in the database. Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> On 6 July 2016 at 23:11, 'scott molinari' via OrientDB < orient-database@googlegroups.com> wrote: > Will a database created with "class.minimumClusters=1" work later with a > server that doesn't have this setting? > > Scott > > -- > > --- > 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.
Re: [orientdb] All those extra clusters in v2.2
Sure, Add this in orientdb-server-config.xml under the properties section: Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> On 6 July 2016 at 15:28, Hugo wrote: > Hi, > > Is there a way to set that a server level? to set it before creating the > DB? > > Regards, > Hugo. > > On Saturday, July 2, 2016 at 2:19:00 PM UTC+2, Luigi Dell'Aquila wrote: >> >> Hi Hugo, >> >> In v 2.2 OrientDB creates, for each class, as many clusters as the number >> of cores available on your machine. This gives advantages when doing >> multi-thread operations. >> If you want, you can return to the previous behavior setting >> minimumClusters=1 (see >> http://orientdb.com/docs/last/Database-Management.html) >> >> Thanks >> >> Luigi >> >> >> >> >> 2016-07-02 13:20 GMT+02:00 Hugo : >> >>> Hello, >>> >>> I have a script that creates a DB, creates all the clusters, classes and >>> properties, and finally does an initial dump of basic data into the DB. >>> This has been working until v2.1, but on v2.2 I am getting a lot of extra >>> clusters that are impacting my initial dump, as it has a lot of links and >>> linksets. >>> >>> e.g. >>> CLUSTERS (collections) >>> ++-++-+-+-+ >>> |# |NAME | ID|CLASS|CONFLICT-STRATEGY|COUNT| >>> ++-++-+-+-+ >>> |0 |default | 3| | |0| >>> |1 |e| 21|E| |0| >>> |2 |e_1 | 22|E| |0| >>> |3 |e_10 | 31|E| |0| >>> |4 |e_11 | 32|E| |0| >>> |5 |e_2 | 23|E| |0| >>> |6 |e_3 | 24|E| |0| >>> |7 |e_4 | 25|E| |0| >>> |8 |e_5 | 26|E| |0| >>> |9 |e_6 | 27|E| |0| >>> |10 |e_7 | 28|E| |0| >>> |11 |e_8 | 29|E| |0| >>> |12 |e_9 | 30|E| |0| >>> |13 |index| 1| | |0| >>> |14 |internal | 0| | |3| >>> |15 |manindex | 2| | |0| >>> |16 |ofunction| 6|OFunction| |0| >>> |17 |orole| 4|ORole| |3| >>> |18 |oschedule| 8|OSchedule| |0| >>> |19 |osequence| 7|OSequence| |0| >>> |20 |ouser| 5|OUser| |3| >>> |21 |v| 9|V| |0| >>> |22 |v_1 | 10|V| |0| >>> |23 |v_10 | 19|V| |0| >>> |24 |v_11 | 20|V| |0| >>> |25 |v_2 | 11|V| |0| >>> |26 |v_3 | 12|V| |0| >>> |27 |v_4 | 13|V| |0| >>> |28 |v_5 | 14|V| |0| >>> |29 |v_6 | 15|V| |0| >>> |30 |v_7 | 16|V| |0| >>> |31 |v_8 | 17|V| |0| >>> |32 |v_9 | 18|V| |0| >>> ++-++-+-+-+ >>> ||TOTAL|| | |9| >>> ++-++-+-+-+ >>> >>> Before, when I created a new DB, I only had 9 clusters, but now I have >>> 32, I've been reading about the default minimumCluster configuration but I >>> don't know if it's related to that. >>> >>> What are those clusters used for? can I delete them? Is there any way >>> that I can create the DB without them? I am not using graph, only document >>> type. >>> >>> Regards, >>> Hugo. >>> >>> -- >>> >>> --- >>> 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-databa...@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. > -- --- 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.
Re: [orientdb] Re: File is locked by another proce
Execute a "jps" from the console or a "ps -ef|grep java" to see any other Java processors. Once found the criminal, kill it. Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> On 6 July 2016 at 12:43, Pugazharasan Thirumalai wrote: > how to fix that problem.. please guide me.. > > -- > > --- > 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.
Re: [orientdb] Re: File is locked by another proce
The database was already opened by a console (with plocal) or you have another server running. Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> On 6 July 2016 at 12:37, Pugazharasan Thirumalai wrote: > I can't access the database, version 2.0.18 > > -- > > --- > 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.
Re: [orientdb] All those extra clusters in v2.2
Right, take a look at: http://orientdb.com/docs/last/Release-2.2.0.html#automatic-usage-of-multiple-clusters . Best Regards, Luca Garulli Founder & CEO OrientDB LTD <http://orientdb.com/> On 2 July 2016 at 07:18, Luigi Dell'Aquila wrote: > Hi Hugo, > > In v 2.2 OrientDB creates, for each class, as many clusters as the number > of cores available on your machine. This gives advantages when doing > multi-thread operations. > If you want, you can return to the previous behavior setting > minimumClusters=1 (see > http://orientdb.com/docs/last/Database-Management.html) > > Thanks > > Luigi > > > > > 2016-07-02 13:20 GMT+02:00 Hugo : > >> Hello, >> >> I have a script that creates a DB, creates all the clusters, classes and >> properties, and finally does an initial dump of basic data into the DB. >> This has been working until v2.1, but on v2.2 I am getting a lot of extra >> clusters that are impacting my initial dump, as it has a lot of links and >> linksets. >> >> e.g. >> CLUSTERS (collections) >> ++-++-+-+-+ >> |# |NAME | ID|CLASS|CONFLICT-STRATEGY|COUNT| >> ++-++-+-+-+ >> |0 |default | 3| | |0| >> |1 |e| 21|E| |0| >> |2 |e_1 | 22|E| |0| >> |3 |e_10 | 31|E| |0| >> |4 |e_11 | 32|E| |0| >> |5 |e_2 | 23|E| |0| >> |6 |e_3 | 24|E| |0| >> |7 |e_4 | 25|E| |0| >> |8 |e_5 | 26|E| |0| >> |9 |e_6 | 27|E| |0| >> |10 |e_7 | 28|E| |0| >> |11 |e_8 | 29|E| |0| >> |12 |e_9 | 30|E| |0| >> |13 |index| 1| | |0| >> |14 |internal | 0| | |3| >> |15 |manindex | 2| | |0| >> |16 |ofunction| 6|OFunction| |0| >> |17 |orole| 4|ORole| |3| >> |18 |oschedule| 8|OSchedule| |0| >> |19 |osequence| 7|OSequence| |0| >> |20 |ouser| 5|OUser| |3| >> |21 |v| 9|V| |0| >> |22 |v_1 | 10|V| |0| >> |23 |v_10 | 19|V| |0| >> |24 |v_11 | 20|V| |0| >> |25 |v_2 | 11|V| |0| >> |26 |v_3 | 12|V| |0| >> |27 |v_4 | 13|V| |0| >> |28 |v_5 | 14|V| |0| >> |29 |v_6 | 15|V| |0| >> |30 |v_7 | 16|V| |0| >> |31 |v_8 | 17|V| |0| >> |32 |v_9 | 18|V| |0| >> ++-++-+-+-+ >> ||TOTAL|| | |9| >> ++-++-+-+-+ >> >> Before, when I created a new DB, I only had 9 clusters, but now I have >> 32, I've been reading about the default minimumCluster configuration but I >> don't know if it's related to that. >> >> What are those clusters used for? can I delete them? Is there any way >> that I can create the DB without them? I am not using graph, only document >> type. >> >> Regards, >> Hugo. >> >> -- >> >> --- >> 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. > -- --- 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.
Re: [orientdb] Re: Relational model vs. Graph database model
On 1 July 2016 at 15:05, Fabio Rinnone wrote: > In OrientDB I've tried this: > > select count(*) as total from ( select expand(in()) from demo where age > > 29 and age < 46 ) where drugname = 'TRIZIVIR' > > that return correct result, but I think that the use of subquery is not > efficient. > Did you create an INDEX (non hash) against demo.age and an HASH_INDEX against drugname? -- --- 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.
Re: [orientdb] find vertex with highest number of edges
Hi,
You're retrieving 33M of rows as result in this way + the order by consumes
a lot of RAM:
select *, *in()*.size() as size from FamilyMember ORDER_BY size DESC
Do you need 33M of results or can you se a limit? Furthermore please can
you add the PARALLEL keyword at the end of the select?
This is the query:
select *, *in()*.size() as size from FamilyMember ORDER_BY size DESC LIMIT
1000 PARALLEL
Best Regards,
Luca Garulli
Founder & CEO
OrientDB LTD <http://orientdb.com/>
On 1 July 2016 at 04:59, Ronnie wrote:
> Hi,
>
> I tried to use the below query to get the count of vertices with most
> edges:
>
> select *, *in()*.size() as size from FamilyMember ORDER_BY size DESC
>
> I have about 33 million vertices and the query seems to be taking ages.
> Please suggest how i can improve the query or suggest possible cause for
> such a long execution time...
>
> I am using 2.2.0 community edition on a stable dedicated machine with
> decent configuration (xeon e5 with 28G RAM)
>
> Ron
>
>
> On Friday, 26 April 2013 08:47:34 UTC+2, Lvc@ wrote:
>>
>> Hi,
>> Topping says well. However you can do something similar to what you did
>> with 1.3.0 by using the new in() function:
>>
>> select url, *in()*.size() as in_size from Links ORDER_BY in_size DESC
>>
>> To count only the edges of type "linked" (label = linked) you can do:
>>
>> select url, *in('linked')*.size() as in_size from Links ORDER_BY in_size
>> DESC
>>
>> or again:
>>
>> select url, *edges('in', 'linked')*.size() as in_size from Links
>> ORDER_BY in_size DESC
>>
>> Lvc@
>>
>>
>> On 25 April 2013 18:20, Yingshou Guo wrote:
>>
>>> Hi,
>>>
>>> Thanks and I'll try it in my usecase.
>>>
>>> Best,
>>>
>>> Guo Yingshou
>>>
>>>
>>>
>>> On Fri, Apr 26, 2013 at 12:13 AM, Topping Bowers <
>>> top...@toppingdesign.com> wrote:
>>>
>>>> I think this:
>>>>
>>>> select *, in_linked.size() AS out_size from V ORDER BY out_size DESC
>>>>
>>>> That's because I have an edge type "linked" - so it's
>>>> in_#{edge.className}.size()
>>>>
>>>>
>>>> On Thu, Apr 25, 2013 at 11:54 AM, Yingshou Guo
>>>> wrote:
>>>>
>>>>> Hi Luca,
>>>>>
>>>>> The problem with me using count() is that I don't know how to use it
>>>>> together with order by clause.
>>>>>
>>>>> In the following example, Would you please tell me how should I order
>>>>> by the number of in_ edge?
>>>>>
>>>>> orientdb> select in_ from V
>>>>>
>>>>> ---+-
>>>>> #| RID |
>>>>> ---+-
>>>>> 0|#-2:1
>>>>> 1|#-2:2
>>>>> 2|#-2:3
>>>>> 3|#-2:4
>>>>> 4|#-2:5
>>>>> 5|#-2:6
>>>>> 6|#-2:7
>>>>> 7|#-2:8
>>>>> 8|#-2:9
>>>>> 9| #-2:10|#38:0
>>>>> 10| #-2:11|[3]
>>>>> 11| #-2:12|#38:2
>>>>> 12| #-2:13|#38:3
>>>>> 13| #-2:14|#38:4
>>>>> 14| #-2:15|#38:5
>>>>> 15| #-2:16|[2]
>>>>> 16| #-2:17|#38:7
>>>>> 17| #-2:18|[6]
>>>>> 18| #-2:19|#37:0
>>>>> 19| #-2:20|#37:1
>>>>>
>>>>> My Query does not work:
>>>>>
>>>>> orientdb> select from V order by count(in_) desc
>>>>>
>>>>> Error:
>>>>> com.orientechnologies.orient.core.sql.OCommandSQLParsingException: Error
>>>>> on
>>>>> parsing command at position #0: Error on parsing command at position #28:
>>>>> Ordering mode 'IN_' not supported. Valid is 'ASC', 'DESC' or nothing
>>>>> ('ASC'
>>>>> by default)
>>>>> Command: select from V order by count(in_)
>>>>>
>>>>>
>>>>> On Thu, Apr 25, 2013 at 11:40 PM, Luca Garulli
>>>>> wrote:
>>>>>
>>>>>> Hi,
>>>>>> count() against edges is very cheap operation (OrientDB keeps track
>>>>>> of such counter like you would do).
>>>>>>
>>>>>> Lvc@
&g
