I am using the dataset from Kaggle . As I had received an error prompting to increase the heap memory size,I assigned heap memory size of 16GB and page cache memory size of 1G, as I have total of 32GB RAM. I left this query to run for an hour but I didn't get any result so I terminated the process. …

This dataset is not intended for processing in a graph database, as it is= a minimal hierarchy with a lot of non-hierarchy related data superimposed over and over again, million of times. But that's it, there's no connection between these hierarchies, or at least, not yet. @michael.hunger - would …

I received the same error from both of your first query and updated query. Am I missing something to mention in it? [image]

Not sure how many attributes are there. Sometimes it helps to split out less frequently used attributes but we also try to minimize how many records we load, as the property records are separate from node-records. Many value graphs elements turn into dense-nodes which can be detrimental for updat…

Seems to be a bug, if you replace the * with the explicit variables it works for me: MATCH (a:Application)-[:HAS_PREVIOUS]->(p:Previous_Application)-[:HAS_PREV_INSTALLMENTS]->(i:Installments_Payment) WITH a, toInteger(i.DAYS_INSTALMENT)-toInteger(i.DAYS_ENTRY_PAYMENT) AS DaysInstallMinusEntry, …

[image] erikazosi: I will also make the database available for download and provide you the link. Please do provide the link.

Here is the link to the dump file of my database: HomeCreditRiskData_erikazosi.zip Google Drive file.

I loaded this query twice and on both execution, I ran into black screen of Neo4j desktop after 7 minutes. [image]

Hmmm, not related to your query, but I often also get black screens when running long queries on AWS. Are you running it on your personal computer? Secondly, i'm running Michael's query Third, your heap is still at 1g ? dbms.memory.heap.max_size=1G

Don't run such a large query in Neo4j browser. Use a client program that streams the data and e.g. consumes it or writes it into a file. Yes heap should probably increased also depending on the profile output. I'll check with your db. Michael

Yes, it's on my personal computer which is running on 16G heap size and 1G is the page cache size.

CURRENT SUBMISSIONS ✦ @mabu.mateApple HealthGraph Agent✦ @venkatasaiprasadpDepGraph Agent✦ @dhiraj.patraRegulatoryRisk GraphAgent✦ @shantanunitw01CineGraph AI✦ @jevlachovKorca Triage Agent✦ @deanfouldsJapan Seismic Risk Intelligence Graph✦ @jonas.koennerConspiracyGraph Agent✦ @mahanteshimathFinSight✦ @prashant7090Detect Cyber Attack✦ @ochiengokumu482VAT-TaxGraph AI✦ @shrikantbhadaneAura-Health-Bot✦ @violet.ols.devRecallScope Agent✦ @tarunnarang1992ReviewGraph AI✦ @epiphanyanEarnings Call Graph Analyst✦ @wanga.15065M-Pesa (Kenya) Insight Agent✦ @kumar20051020shivamVibeGraph AI✦ @jakub.kierznowskiiiDrugPath✦ @vinod.nageshwarGeospatial Supply Chain Agent✦ @winleexzCPF Customer Agent✦ @hellopriyanshu4FraudGraph Sentinel✦ @ayushdeosinghHostLens AI✦ @joslatMarketMind✦ @priyagijain IPL Cricket Intelligence Agent ✦ @Rodrigo-Tenorio Chess Analytics Assistant ✦ Submit your Aura Agent Project to appear here

Neo4j Online Community

How to fetch millions of data faster?

Neo4j Graph Platform Cypher

yeshveer.yadav (Yeshveer Yadav) October 18, 2019, 4:59am 31

Topic		Replies	Views
Need advice on performance tuning for Neo4j Cypher on a large dataset with relationships Cypher performance , cypher	16	327	July 9, 2025
Took 11 hours to finish running query. Need Help Query Tuning an APOC Function to Update Graph Import / Export	7	1045	October 13, 2021
How best to do parallel processing Procedures & APOC	15	7679	February 24, 2020
Memory settings for big databases Server performance	40	3463	August 1, 2019
Extremely slow query when profile looks very good? Cypher	11	4165	October 3, 2019

Take the Course Then Join The Aura Agent Hackathon

How to fetch millions of data faster?

Related topics

Take the Course Then Join
The Aura Agent Hackathon