Hi everyone I've been coding for a few months and this is my first attempt at a web app using GRANDstack. I'm extremely new to all this so forgive the janky looking website. I created the design and everything by myself, attempting to build something for my church.
I've built my app here using grandstack and I've been having issues with long loading times. Could anyone help with some suggestions of what to do to shorten the loading times in my web app?
Can you provide some code snippets here for the types of queries you're using? That might help us give you some advice.
Alright. So here is one of my more complex GraphQL queries. I don't know so much about this as I'm fairly new, I'm wondering if it's because of the volume of date I am requesting from this query?
export const DISPLAY_MEMBER = gql`
query displayMember($id: ID) {
displayMember(id: $id) {
id
firstName
lastName
email
phoneNumber
whatsappNumber
pictureUrl
gender {
gender
}
maritalStatus {
status
}
dob {
date {
formatted
day
month
year
}
}
bacenta {
name
leader {
firstName
lastName
}
centre {
name
town {
name
bishop {
firstName
lastName
}
}
campus {
name
bishop {
firstName
lastName
}
}
}
}
ministry {
id
name
leader {
firstName
lastName
}
}
occupation {
occupation
}
title {
Title {
title
}
yearAppointed {
year
}
}
history {
timeStamp {
hour
minute
}
created_at {
date {
formatted
}
}
loggedBy {
id
firstName
lastName
}
historyRecord
}
leadsBacenta {
id
name
leader {
firstName
lastName
}
centre {
id
name
town {
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
}
leadsMinistry {
id
name
}
townBishop {
id
name
}
campusBishop {
id
name
}
}
}
How many displayMember nodes are in the database? Do you have a database index on the id property of displayMember?
In general it's a good idea to create indexes in the database on any properties that you'll be using to look up nodes by property value (i.e. the starting point of the graph traversal).