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

Query execution taking too much time #2488

Open
ddaa2000 opened this issue Jul 22, 2022 · 0 comments
Open

Query execution taking too much time #2488

ddaa2000 opened this issue Jul 22, 2022 · 0 comments
Labels
x:perf Performance related issue/PR ( not affecting functionality )

Comments

@ddaa2000
Copy link

RedisGraph 2.8.14
After using following statements to create the graph:

CREATE (n0 :L3{k20:'W'}) RETURN *;
CREATE (n1 :L2{k14:true}) RETURN *;
CREATE (n2 :L0 :L2 :L3{k4:true, k5:'Gv', k11:1396799742, k13:'EO', k19:false, k21:true, k22:true}) RETURN *;
CREATE (n3 :L1{k6:'dE7eLMDx', k10:1396799742}) RETURN *;
CREATE (n4 :L2{k11:1396799742}) RETURN *;
CREATE (n5 :L0 :L2{k0:true, k5:'o', k12:'q'}) RETURN *;
CREATE (n6) RETURN *;
CREATE (n7 :L3{k18:'n'}) RETURN *;
CREATE (n8) RETURN *;
CREATE (n9) RETURN *;
CREATE (n10 :L0 :L2{k2:false, k16:''}) RETURN *;
CREATE (n11 :L1) RETURN *;
CREATE (n12) RETURN *;
CREATE (n13 :L3{k22:true}) RETURN *
CREATE (n14 :L1{k8:705930028}) RETURN *;
CREATE (n15) RETURN *;
CREATE (n16 :L3{k19:false, k22:false}) RETURN *;
CREATE (n17) RETURN *;
CREATE (n18 :L0{k5:'o23W'}) RETURN *;
CREATE (n19 :L3{k20:'ivz', k22:false}) RETURN *;
CREATE (n20 :L1{k6:'iP', k9:'YPRv', k10:1396799742}) RETURN *;
CREATE (n21) RETURN *;
CREATE (n22 :L0{k0:false}) RETURN *;
CREATE (n23 :L0 :L2{k11:-515419948, k12:'V46acujK'}) RETURN *;
CREATE (n24 :L1 :L2{k8:529423871, k14:true, k16:'FzZ1'}) RETURN *;
CREATE (n25) RETURN *;
CREATE (n26 :L1{k7:'', k9:''}) RETURN *;
CREATE (n27 :L1{k8:1452777953}) RETURN *;
CREATE (n28) RETURN *;
CREATE (n29 :L2{k13:'Y'}) RETURN *;
CREATE (n30 :L0 :L2 :L3{k13:'Ii7owK', k14:false, k18:'xIs'}) RETURN *;
CREATE (n31 :L3{k17:false, k18:'TZthSLx', k22:true}) RETURN *;
CREATE (n32 :L3{k22:true}) RETURN *;
CREATE (n33 :L1 :L2{k13:'y7kfujSV'}) RETURN *;
CREATE (n34 :L2{k12:'', k15:-1696622604}) RETURN *;
CREATE (n35 :L2 :L3{k15:-659087668, k17:false, k18:'y'}) RETURN *;
CREATE (n36 :L0 :L1{k1:true, k8:1715384594, k10:-752114626}) RETURN *;
CREATE (n37 :L2{k11:-2035517046, k12:'efg', k16:'X9'}) RETURN *;
CREATE (n38 :L0{k2:false, k5:'IV'}) RETURN *;
CREATE (n39) RETURN *;
CREATE (n40 :L1 :L2{k7:'S', k8:-515419948}) RETURN *;
CREATE (n41) RETURN *;
CREATE (n42 :L3) RETURN *;
CREATE (n43 :L0{k0:true}) RETURN *;
CREATE (n44 :L2{k14:false, k15:210099986}) RETURN *;
CREATE (n45 :L3{k18:'LhTW', k19:true, k21:true}) RETURN *;
CREATE (n46) RETURN *;
CREATE (n47 :L2) RETURN *;
CREATE (n48 :L0 :L2) RETURN *;
CREATE (n49) RETURN *;
CREATE (n50 :L3{k18:''}) RETURN *;
CREATE (n51) RETURN *;
CREATE (n52 :L1{k6:'wvAQ7'}) RETURN *;
CREATE (n53 :L3) RETURN *;
CREATE (n54 :L0) RETURN *;
CREATE (n55 :L0) RETURN *;
CREATE (n56) RETURN *;
CREATE (n57) RETURN *;
MATCH (n3 :L1{k6:'dE7eLMDx', k10:1396799742}), (n23 :L0 :L2{k11:-515419948, k12:'V46acujK'}) MERGE (n3)<-[r0 :T2{k35:false}]-(n23) RETURN *;
MATCH (n10 :L0 :L2{k2:false, k16:''}), (n14 :L1{k8:705930028}) MERGE (n10)<-[r1 :T0]-(n14) RETURN *;
MATCH (n30 :L0 :L2 :L3{k13:'Ii7owK', k14:false, k18:'xIs'}), (n56) MERGE (n30)-[r2 :T0{k26:'Aud'}]->(n56) RETURN *;
MATCH (n39), (n36 :L0 :L1{k1:true, k8:1715384594, k10:-752114626}) MERGE (n39)<-[r3 :T2{k35:false}]-(n36) RETURN *;
MATCH (n39), (n41) MERGE (n39)-[r4 :T1{k31:-486220737}]->(n41) RETURN *;
MATCH (n39), (n55 :L0) MERGE (n39)<-[r5 :T1{k31:-249986414, k33:-1696622604}]-(n55) RETURN *;
MATCH (n43 :L0{k0:true}), (n6) MERGE (n43)<-[r6 :T2]-(n6) RETURN *;
MATCH (n50 :L3{k18:''}), (n18 :L0{k5:'o23W'}) MERGE (n50)<-[r7 :T0]-(n18) RETURN *;
MATCH (n51), (n12) MERGE (n51)<-[r8 :T0{k26:''}]-(n12) RETURN *;
MATCH (n51), (n21) MERGE (n51)-[r9 :T0{k25:'D5g5oISuU', k26:'', k28:true}]->(n21) RETURN *;
MATCH (n54 :L0), (n10 :L0 :L2{k2:false, k16:''}) MERGE (n54)<-[r10 :T0]-(n10) RETURN *;
MATCH (n56), (n15) MERGE (n56)<-[r11 :T1{k29:1157547957, k34:true}]-(n15) RETURN *;
MATCH (n56), (n35 :L2 :L3{k15:-659087668, k17:false, k18:'y'}) MERGE (n56)-[r12 :T1{k32:-659087668, k34:false}]->(n35) RETURN *;
MATCH (n56), (n41) MERGE (n56)<-[r13 :T2{k36:-1294654749, k38:-879613814, k39:-564540574}]-(n41) RETURN *;

Then execute the following two queries:
MATCH (n0)<-[r0 *1..]-(n1), (n2) WHERE (true IS NOT NULL) WITH r0 WHERE (1513283376 <= 1363834561) WITH DISTINCT * WHERE ('' <> '78M') MATCH (n3)-[r1 *]->(n4 :L3) WHERE ('p' STARTS WITH 'tdwsk') OPTIONAL MATCH (n4) WHERE (NOT true) RETURN 0;

MATCH (n0)<-[r0 *1..]-(n1) WHERE (601257744 <= -2122102612) WITH DISTINCT r0, n0 RETURN 0;

RedisGraph version 2.8.14 cannot return results for more than 30s, whereas Neo4j version 4.4.5 can return results within 100ms on average.

@LiorKogan LiorKogan added the x:perf Performance related issue/PR ( not affecting functionality ) label Jul 22, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
x:perf Performance related issue/PR ( not affecting functionality )
Projects
None yet
Development

No branches or pull requests

2 participants