Alex
ATApache TinkerPop
•Created by Alex on 12/11/2024 in #questions
How to create indexes by Label?
In search of performance improvements, the AWS Neptune experts suggested that I create some indexes. To better contextualize, I have 3 operations in a single POST endpoint with the database. A query of previous data bringing the relationships of a specific ID, a deletion of edges if there is a registration in the database and a registration/update of vertices and edges. Today I am trying to attack two problems. Improve the performance of the creation that takes approximately 150ms and improve the performance of the query that is currently bogging down between 1.2-17 seconds.
Is it possible to create an index for vertexes and edges by specifying them by label since I have vertices and edges with different labels that have different properties? Does anyone know what this implementation would look like? In my current implementation I do it in a simple way as follows: client_write = client.Client(neptune_url, "g", message_serializer=serializer.GraphSONMessageSerializer()) queries = [ "graph.createIndex('journey_id', Vertex.class)", "graph.createIndex('person_type', Vertex.class)", "graph.createIndex('relationship_type', Edge.class)" ] for query in queries: client_write.submit(query).all().result()
Is it possible to create an index for vertexes and edges by specifying them by label since I have vertices and edges with different labels that have different properties? Does anyone know what this implementation would look like? In my current implementation I do it in a simple way as follows: client_write = client.Client(neptune_url, "g", message_serializer=serializer.GraphSONMessageSerializer()) queries = [ "graph.createIndex('journey_id', Vertex.class)", "graph.createIndex('person_type', Vertex.class)", "graph.createIndex('relationship_type', Edge.class)" ] for query in queries: client_write.submit(query).all().result()
11 replies
ATApache TinkerPop
•Created by Alex on 11/28/2024 in #questions
How to Work with Transactions with Gremlin Python
10 replies
ATApache TinkerPop
•Created by Alex on 10/11/2024 in #questions
Possibilities to improve performance on query?
7 replies
ATApache TinkerPop
•Created by Alex on 10/10/2024 in #questions
Neptune Cluster Balancing Configuration
5 replies
ATApache TinkerPop
•Created by Alex on 9/24/2024 in #questions
How to improve Performance using MergeV and MergeE?
I made an implementation similar to this:
g.mergeV([(id): 'vertex1'].option(onCreate, [(label): 'Person', 'property1': 'value1', 'updated_at': 'value2']).option(onMatch, ['updated_at': 'value2'])).mergeV([(id): 'vertex2'].option(onCreate, [(label): 'Person', 'property1': 'value1', 'updated_at': 'value2']).option(onMatch, ['updated_at': 'value2'])).mergeV([(id): 'vertex3'].option(onCreate, [(label): 'Person', 'property1': 'value1', 'updated_at': 'value2']).option(onMatch, ['updated_at': 'value2']))
So I'm send 2 requests to neptune. The first one with 11 vertexes and the second with 10 edges in two different requests and doing a performance test using neptune. The duration of the process for this amount of content is like 200ms-500ms. Is there a way to improve this query to be faster? For connection I'm using gremlin = client.Client(neptune_url, 'g', transport_factory=lambda: AiohttpTransport(call_from_event_loop=True), message_serializer=serialier.GraphSONMessageSerializer()) so I send this query by gremlini.submit(query)4 replies
ATApache TinkerPop
•Created by Alex on 8/7/2023 in #questions
How do I make a ssl connection using only ARN from neptune (AWS)
I have a simple connection in my project using
remotecon = DriverRemoteConnection(neptune_url)
But now I need to implement a solution using SSL Connection, I dont have username and password, only the arn of neptune. Does someone know how to implement it ?
Thanks in advance!
2 replies