Head's Up! These forums are read-only. All users and content have migrated. Please join us at community.neo4j.com.
10-07-2021 12:21 AM
Hi Everyone
I have started a project with Aura Free, and I keep running into a "Task timed out" error. These queries never time out when using Neo4j desktop, so I'm wondering what I could be doing wrong and perhaps some best practices for optimising queries in Aura
This is the graphql query I'm running using the autogenerated cypher queries.
query($id: ID) {
members(where: { id: $id }, options: { limit: 1 }) {
id
firstName
middleName
lastName
fullName
email
phoneNumber
whatsappNumber
pictureUrl
gender {
gender
}
maritalStatus {
status
}
dob {
date
}
bishop {
id
firstName
lastName
fullName
}
bacenta {
id
name
leader {
firstName
lastName
}
centre {
id
name
town {
id
name
bishop {
id
firstName
lastName
fullName
}
}
campus {
id
name
bishop {
id
firstName
lastName
fullName
}
}
}
}
ministry {
id
name
leader {
firstName
lastName
}
}
occupation {
occupation
}
titleConnection {
edges {
dateAppointed
node {
title
}
}
}
history(options: { limit: 3 }) {
id
timeStamp
created_at {
date
}
loggedBy {
id
firstName
lastName
}
historyRecord
}
leadsBacenta {
id
name
leader {
firstName
lastName
}
centre {
id
name
town {
id
name
bishop {
firstName
lastName
}
}
campus {
id
name
bishop {
firstName
lastName
}
}
}
}
leadsCentre {
id
name
town {
id
name
bishop {
id
firstName
lastName
}
}
campus {
id
name
bishop {
id
firstName
lastName
}
}
}
leadsTown {
id
name
bishop {
id
firstName
lastName
}
}
leadsCampus {
id
name
bishop {
id
firstName
lastName
}
}
leadsSonta {
id
name
}
leadsBasonta {
id
name
sonta {
id
}
}
leadsMinistry {
id
name
}
isBishopForTown {
id
name
}
isBishopForCampus {
id
name
}
isAdminForBishop {
id
firstName
lastName
}
isAdminForCampus {
id
name
}
isAdminForTown {
id
name
}
}
}
10-07-2021 11:38 PM
It would be good if you could share the generated cypher query,
the volume of data you have in aura free and the execution plan for the query (e.g. from Desktop)
Then please also raise this with the aura support portal
All the sessions of the conference are now available online