wixData.aggregate Performance

I'm executing the below code on a collection which holds the purchased tickets for each event (event id is a reference field within this collection).

I've added a console.time() and it shows that this takes around 0.5 sec. Seems to me a very poor performance as I need to perform additional queries in order to return a valuable result to the end user and the total takes around 1.5 sec.

I've come to know about this since the site monitoring show timeouts when invoking the API.

Is there a way to improve the performance for this kind of query? Will it help to replace the reference field with a regular field which will hold the event id?

const filter = wixData.filter().eq("eventId", eventId);

//const having = wixData.filter().gt("maxPopulation", 1000000);

// .filter(filter)

return wixData.aggregate("MyTickets")

.filter(filter)

.group("ticketId")

.count()

.run()

.then((results) => {

if (results.items.length > 0) {

console.log("items " + JSON.stringify(results.items))

console.timeEnd("getTicketsSum");

// let items = results.items;

// let numItems = results.length;

// let hasNext = results.hasNext();

}

resolve(results);

})

.catch((error) => {

let errorMsg = error.message;

let code = error.code;

reject(error)

});