Slow performance on Exact filter on relationship.

[ericknyoto]

I faced an issue, the performance really slow and even the mysql was time out for searching in a table of a million rows.

$invoices = QueryBuilder::for(Invoice::class)
            ->allowedFilters([
                AllowedFilter::exact('invoice_number'),
                AllowedFilter::exact('type'),
                AllowedFilter::exact('invoiceDetails.order_id'),
                AllowedFilter::exact('invoiceDetails.order_number'),
                AllowedFilter::exact('sales_channel_id'),
            ])
            ->allowedIncludes('invoiceDetails')
            ->get();

Any idea how to solve this? Thanks.