Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Simple CYPHER query is much slower than SQL one on vector sample database (only name query with limit=25) #1998

Open
ExtReMLapin opened this issue Feb 17, 2025 · 0 comments

Comments

@ExtReMLapin
Copy link
Contributor

ExtReMLapin commented Feb 17, 2025

Hello,

Version used :

 [ArcadeDBServer] <ArcadeDB_0> ArcadeDB Server v25.1.1 (build b1c737224fcab342eb60c36469cde61e0bb20271/1737875480429/main) is starting up...
 [ArcadeDBServer] <ArcadeDB_0> Running on Linux 6.8.0-49-generic - OpenJDK 64-Bit Server VM 17.0.13

Issue :

We would expect

match (n:Node) return n.name

to be as fast as

SELECT nodeOBJ.name AS name
		  FROM (MATCH {type: Node, as: nodeOBJ}
		  RETURN nodeOBJ)

But Cypher (with limit 25) takes 5.7s

Image

And SQL takes 6ms

Image

All records in SQL takes ~4s

Image

DB Imported from guide :

import database https://dl.fbaipublicfiles.com/fasttext/vectors-crawl/cc.en.300.vec.gz
  with distanceFunction = 'cosine', m = 16, ef = 128, efConstruction = 128;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant