[orientdb] Large DB size

2015-07-06 Thread Kalatheeswaran TM
Hi, I have a DB of 1 milllion vertices in Table A which has 4 edges to four other tables. All the 4 tables don't have records greater than 100,000. The total DB size is 1GB. I use only Lightweight edges. Is there a way to reduce the DB size. Kalatheeswaran -- --- You received this message

Re: [orientdb] Select vertexes based on inherited class type

2015-07-06 Thread hartmut bischoff
On Monday, July 6, 2015 at 12:01:26 PM UTC+2, @raph wrote: I need to execute only one query to get all the data I am looking for. right, just call database/{database_name}.get and you get anything. you just have to grep the data from the json-data-object

[orientdb] where in.@rid = someRID does not work but where someRID in in.@rid works, why?

2015-07-06 Thread mehdi shams
Hi, I have read in documentation that we can use something like: select from User where in.@rid = #12:2 for example, but it did not return any result or error for me, I have tried the following: select from User where #12:2 in in.@rid and worked perfectly. also tried select from User

[orientdb] Slow pagination on links?

2015-07-06 Thread Khaled Bakhit
Hello all, I'm using Orientdb 2.0.10, and I'm having performance issues when I want to perform pagination on edges. I have the following set up ( using Light weight edges, 4 clusters round robin selection per class) : User ( userid, country ) Movie ( movieid, name ) Likes User -- Likes ---

[orientdb] Re: IMPORTANT: Are you using the Object Database interface?

2015-07-06 Thread M B
We are using it heavily in embedded mode. The biggest missing in 2.0 is the changes to the document database pool were not carried over for the object database pool. -- --- You received this message because you are subscribed to the Google Groups OrientDB group. To unsubscribe from this

[orientdb] SQL explain indicates many documents read on indexed SELECT statement

2015-07-06 Thread M B
orientdb 2.0.8 Can someone explain what is going on here. I have a SELECT with a sort by that was missing a field which is fine, I've corrected it, but it appears that EXPLAIN is indicating that a lot of records are being read even though the query is now indexed and sorted properly. Here is

Re: [orientdb] Large DB size

2015-07-06 Thread Kalatheeswaran TM
This is almost 1 edge per 1 vertex of answer4rpt class -- --- 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

Re: [orientdb] Large DB size

2015-07-06 Thread Kalatheeswaran TM
No totally I have 996,045 edges in the database -- --- 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,

Re: [orientdb] How to convert an OWL or RDF vocabulary (ontology) to an OrientDB class format?

2015-07-06 Thread Geof Pawlicki
Thanks, Riccardo. It's hard to imagine doing much of anythign useful without class inheritance so using OSQL makes sense. . . which sortof puts me back to a comparatively manual approach for loading a fairly large schema (~2500 lines of OWL). Among other things, this seems an error prone way

Re: [orientdb] Large DB size

2015-07-06 Thread Andrey Lomakin
But it does not mean that you have only one edge in database , is it correct ? On Mon, Jul 6, 2015 at 8:31 PM Kalatheeswaran TM tmkra...@gmail.com wrote: I mean an edge exists between the vertices of class Answer4Rpt to class SurveyParticipant -- --- You received this message because you

Re: [orientdb] Large DB size

2015-07-06 Thread Andrey Lomakin
What do you mean for 1 edge ? On Mon, Jul 6, 2015 at 6:55 PM Kalatheeswaran TM tmkra...@gmail.com wrote: Hi, I have attached the image containing files and their sizes ordered from largest size. If you need I can provide the remaining files too, but they are all small I have created 2

Re: [orientdb] Large DB size

2015-07-06 Thread Kalatheeswaran TM
I mean an edge exists between the vertices of class Answer4Rpt to class SurveyParticipant -- --- 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

[orientdb] what is your experience with orientdb tuning of wal

2015-07-06 Thread M B
orientdb 2.0.8 I have two databases, both are embedded, and in dev mode and sometimes in production we crash the JVM. The databases have very few updates, mostly creates and deletes, none of which ever overlap (i.e. something created will stay created for several days) I've thought about

[orientdb] When to use Solr vs. Orient Lucene index?

2015-07-06 Thread Thelonius Buddha
We have some needs around basic text search of internal documents. From what I'm reading, it appears OrientDB can handle much of the basic searching needs. Can anyone provide insight on when I may need to include or migrate to Solr for text search? Here are some of my concerns: 1. The

Re: [orientdb] Select vertexes based on inherited class type

2015-07-06 Thread Riccardo Tasso
What about CLASSES command? It should return: - class name - superclass name - list of clusters - number of records Cheers, Riccardo 2015-07-05 18:30 GMT+02:00 @raph raf.bra...@gmail.com: Thanks Hartmut, But I was hoping to get the solution with an sql query, I am using HTTP

Re: [orientdb] OrientDB lifecycle: please help on contributing to OrientDB

2015-07-06 Thread Riccardo Tasso
Thank you Luca, and thanks to your team too. The quality improvement has been tangible in the last year, while the great support to the community has been great since the beginning. Riccardo 2015-07-04 10:53 GMT+02:00 Luca Garulli l.garu...@orientdb.com: Hi guys, Yesterday we released

Re: [orientdb] Large DB size

2015-07-06 Thread Andrey Lomakin
Hi, To understand exactly what consumes space on your disk could you provide names of files in database and their sizes ? On Mon, Jul 6, 2015 at 6:11 PM Kalatheeswaran TM tmkra...@gmail.com wrote: Hi, Thanks for your reply Is it due to increasing versions due to creation of edges. I can't

Re: [orientdb] Large DB size

2015-07-06 Thread Kalatheeswaran TM
Hi, Thanks for your reply Is it due to increasing versions due to creation of edges. I can't export/import because we are handling data in magnitudes higher than the one specified. Regards Kalatheeswaran -- --- You received this message because you are subscribed to the Google Groups

Re: [orientdb] Increment of vertices version control doesn't work

2015-07-06 Thread Andrey Lomakin
Hi, Please never set OGlobalConfiguration.CACHE_LOCAL_ENABLED to false, if you do not want to experience data consistency problems. On Mon, Jul 6, 2015 at 6:09 PM Kalatheeswaran TM tmkra...@gmail.com wrote: *The following is the code I use:* public void createEdge(TLBTables fromTable,

Re: [orientdb] Re: where in.@rid = someRID does not work but where someRID in in.@rid works, why?

2015-07-06 Thread Luigi Dell'Aquila
Hi Mehdi, could you point me to that docs page? I'll update it quickly Thanks Luigi 2015-07-06 11:46 GMT+02:00 mehdi shams mehry...@gmail.com: thank you so much, but i remember in documentation it was like: where in.@class = someclass is documentation wrong or old? isn't such queries

Re: [orientdb] Increment of vertices version control doesn't work

2015-07-06 Thread Kalatheeswaran TM
Hi, Thanks for the reply. I found it in the docs: Regards, Kalatheeswaran -- --- 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

Re: [orientdb] Increment of vertices version control doesn't work

2015-07-06 Thread Luca Garulli
Hi, Just fixed the documentation, thanks. In order to speed up edge creation, could you share the code you used? Best Regards, Founder CEO OrientDB http://orientdb.com/ On 6 July 2015 at 16:44, Kalatheeswaran TM tmkra...@gmail.com wrote: Hi, In the page here:

Re: [orientdb] Large DB size

2015-07-06 Thread Andrey Lomakin
Hi, You may perform export/import of database it will reduce size of database. On Mon, Jul 6, 2015 at 1:05 PM Kalatheeswaran TM tmkra...@gmail.com wrote: Hi, I have a DB of 1 milllion vertices in Table A which has 4 edges to four other tables. All the 4 tables don't have records greater than

Re: [orientdb] Large DB size

2015-07-06 Thread Kalatheeswaran TM
Please provide me some time. I have to recreate the db for the 1 million to show the stats. -- --- 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

Re: [orientdb] Increment of vertices version control doesn't work

2015-07-06 Thread Kalatheeswaran TM
Hi, In the page here: http://orientdb.com/docs/last/SQL-Delete-Edge.html Also can you provide a few tips for increasing the speed during insertion and edge creation. I have tried those found in docs and am able to insert 100,000 vertices in 20 seconds. Creation of one edge from these

Re: [orientdb] Increment of vertices version control doesn't work

2015-07-06 Thread Kalatheeswaran TM
Is there any alternative to it? What else can be done for increasing the speed of creation of edges? -- --- 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

Re: [orientdb] Increment of vertices version control doesn't work

2015-07-06 Thread Kalatheeswaran TM
*The following is the code I use:* public void createEdge(TLBTables fromTable, TLBTables toTable, String edgeName, String mappedColumnName, String mappingColumn) { OGlobalConfiguration.CACHE_LOCAL_ENABLED.setValue(false); OrientBaseGraph graph = new

[orientdb] Exception while starting distributed server [orientdb-community-2.0.10]

2015-07-06 Thread Laurent Polese
Hi, I've been working with OrientDB for about 2 weeks now and I need to bench server in distributed mode. I read that I can either start a second server, and databases will hot sync, or copy the databases directory to the new master and start it. I have problems with both solutions. I have a

Re: [orientdb] Increment of vertices version control doesn't work

2015-07-06 Thread Luca Garulli
Hi, You should set *RID_BAG_EMBEDDED_TO_SBTREEBONSAI_THRESHOLD* to -1. Where did you find the setting INDEX_EMBEDDED_TO_SBTREEBONSAI_THRESHOLD ? Best Regards, Founder CEO OrientDB http://orientdb.com/ On 4 July 2015 at 15:05, Kalatheeswaran TM tmkra...@gmail.com wrote: Please provide any

Re: [orientdb] Large DB size

2015-07-06 Thread Kalatheeswaran TM
Hi, I have attached the image containing files and their sizes ordered from largest size. If you need I can provide the remaining files too, but they are all small I have created 2 tables with 1 million records in one table and 215,098 records in the other. I have created edges for the