Performance Degradation on Simple Query with ArcadeDB Embedded Version 24.5.1 (original) (raw)

ArcadeDB Version: 24.5.1 (Embedded)
Operating System: Windows
JDK Version: 11
Nodes: 8357
Edges: 13557

Problem Description:
I am experiencing significant performance issues when running a simple query on ArcadeDB embedded version 24.5.1. The query in question is as follows:
MATCH (n:V_6)-[e:E_36]-(p:V_8) WHERE n.id = 647 RETURN n, p LIMIT 1
This query takes approximately 4 seconds to retrieve a result, which seems excessive given the dataset size (8357 nodes and 13557 edges). I would expect much faster execution times for a query of this simplicity.
I have searched through the documentation but could not find any clear information regarding performance tuning or optimization guidelines for embedded use cases. This issue occurs consistently with the same query structure and dataset size.

Any suggestions for improving query performance, configuration changes, or indexing strategies would be greatly appreciated.