Increment of vertices version control doesn't work

[Kalatheeswaran TM]

Hi,
I am using the Graph model and when I try to use the following code to control the version increment it doesn't work,

OGlobalConfiguration.INDEX_EMBEDDED_TO_SBTREEBONSAI_THRESHOLD.setValue(-1);

Does the DB size gets increased with increase in the versions during the creation of edges.

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.

Any help will be greatly useful.

Thanks,
Kalatheeswaran

[Luca Garulli]

Are you running in distributed mode? About this line of code:

OGlobalConfiguration.INDEX_EMBEDDED_TO_SBTREEBONSAI_THRESHOLD.setValue(-1);

When did you execute it? It must be done before any usage of OrientDB.

Best Regards,

Luca Garulli

CEO at Orient Technologies LTD

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-databa...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Kalatheeswaran Thiru Meganathan]

No I am not running in distributed mode. I ran that code before opening the dB. What do you mean by usage? I create the db alone from the studio

How about the size. Can it be reduced?  I am using light weight edges only

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/m69v51yRq6U/unsubscribe.
To unsubscribe from this group and all its topics, send an email to orient-databa...@googlegroups.com.

[Kalatheeswaran TM]

Please provide any help. Its urgent

Kalatheeswaran

[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

[Kalatheeswaran TM]

Hi,
Thanks for the reply. I found it in the docs:



Regards,
Kalatheeswaran

[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 vertices takes around 60 seconds.

I am running in plocal mode
 
Kalatheeswaran

[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

[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 OrientGraphNoTx(orientDBLocation);
        try {

            for (Vertex fromClassV : graph.getVerticesOfClass(fromTable
                    .toString())) {
                StringBuffer sqlBuf = new StringBuffer("CREATE EDGE ");
                sqlBuf.append(edgeName);
                sqlBuf.append(" FROM ");
                sqlBuf.append(fromClassV.getId());
                sqlBuf.append(" TO (SELECT FROM ");
                sqlBuf.append(toTable.toString());
                sqlBuf.append(" WHERE ");
                sqlBuf.append(mappedColumnName);
                sqlBuf.append("=");
                sqlBuf.append(fromClassV.getProperty(mappingColumn));
                sqlBuf.append(")");

                graph.command(new OCommandSQL(sqlBuf.toString())).execute();

                log.info("Successfully Created Edge " + fromTable + "->"
                        + toTable + " with Id[" + fromClassV.getId() + "]");
            }
        } catch (Exception e) {
            graph.rollback();
        } finally {
            graph.shutdown();
          OGlobalConfiguration.CACHE_LOCAL_ENABLED.setValue(true);
        }
 }

I am not sure of the correct way to use OGlobalConfiguration.CACHE_LOCAL_ENABLED. I get the same speed results with and without it.

Also is there any API call to get the all the vertices of a class from a specified index instead of getting all the vertices like in graph.getVerticesOfClass()

Thanks for your help

Regards,
Kalatheeswaran

[Andrey Lomakin]

Hi,
Please never set OGlobalConfiguration.CACHE_LOCAL_ENABLED to false, if  you do not want to experience data consistency problems.

--

[Kalatheeswaran TM]

Is there any alternative to it? What else can be done for increasing the speed of creation of edges?

[Kalatheeswaran TM]

Please provide some suggestions?