Logan
09/24/2021, 12:44 AMconst valid = await client.prisma.invites
.aggregate({
_count: {
inviterId: true,
},
where: {
inviterId: mUser,
valid: true,
serverId: message.guildID,
},
})
.catch((e: unknown) => client.logger.error(String(e)));
const invalid = await client.prisma.invites
.aggregate({
_count: {
inviterId: true,
},
where: {
inviterId: mUser,
valid: false,
serverId: message.guildID,
},
})
.catch((e: unknown) => client.logger.error(String(e)));
const result = await client.prisma.invites
.groupBy({
by: ["inviterId"],
_count: {
inviterId: true,
},
where: {
serverId: message.guildID,
inviterId: mUser,
},
})
Hey, just wondering if theres a good way of speeding these query's up? We are using SQL database