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.


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

10 |1000

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


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

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 ·


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 ·