question

bharat.asnani_190772 avatar image
bharat.asnani_190772 asked bettina.swynnerton commented

What is the maximum number of vertices retrieved in a Graph query?

What is the maximum number of records that are retrieved in a graph query?

For eg.

g.V().hasLabel("Acc")

How many vertices data will be retrieved? What is the limit?

dsegraph
10 |1000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

1 Answer

bettina.swynnerton avatar image
bettina.swynnerton answered bettina.swynnerton commented

Hi,

I am assuming that you are using DSE Graph 6.8.

Under the hood, the query g.V().hasLabel("Acc") will execute as follows:

SELECT * FROM graphname.Acc

I am not aware of a hard limit with this type of query.

However, there are limits that apply to query execution time, and I would expect that you would run into the default limit for the real-time evaluation timeout with large tables, by default 30 seconds.

The question here is what you want to achieve with reading the entire vertex table. DSEGraphFrames with Spark might be a better alternative for operations where you want to read the entire table.

Would you update your question with more context?

2 comments Share
10 |1000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

bharat.asnani_190772 avatar image bharat.asnani_190772 commented ·

Hi,


Thanks for your response.


In our use case we have a thousands of different vertices which will be retrieved in a single transaction. So, we need to know what is the limit on data returning in a single transaction.


Any help would be appreciated.

0 Likes 0 ·
bettina.swynnerton avatar image bettina.swynnerton ♦♦ bharat.asnani_190772 commented ·

Hi @bharat.asnani_190772,

I am not sure I understand your requirement here.

However, as explained in a previous answer:

Cassandra as the underpinning database has no concept for transactions, which means that also Tinkerpop transactions do not provide the kind of ACID guarantee that you are hoping for.


0 Likes 0 ·