Improve performance of widgets

4️⃣v4

I got three widgets.

The logic for all 3 is pretty simple, query the databse for all the datapoints grouped by day in a given period to draw a graph, get their sum to get the main value. and get the previous period's count to calculate the growth rate.

This takes 3+ seconds on the server, on a resource with ~ 400 datapoints.

I'd like to speed this up but I am not sure which strategy to use, code:

$leads = Lead::where('campaign_id', $this->record->id);

$new_leads_chart = Trend::query($leads)->between($curPeriod[0], $curPeriod[1])->perDay()->count()->pluck('aggregate')->all();

$old_leads = $leads->whereBetween('created_at', $prevPeriod)->count();

$leadGrowthRate = $this->calculateGrowth($old_leads, array_sum($new_leads_chart));

return Stat::make('Recent Leads', array_sum($new_leads_chart))->chart($new_leads_chart)->indication($this->indicateGrowth($leadGrowthRate, '%'));

$leads = Lead::where('campaign_id', $this->record->id);

$new_leads_chart = Trend::query($leads)->between($curPeriod[0], $curPeriod[1])->perDay()->count()->pluck('aggregate')->all();

$old_leads = $leads->whereBetween('created_at', $prevPeriod)->count();

$leadGrowthRate = $this->calculateGrowth($old_leads, array_sum($new_leads_chart));

return Stat::make('Recent Leads', array_sum($new_leads_chart))->chart($new_leads_chart)->indication($this->indicateGrowth($leadGrowthRate, '%'));

Filament•2w ago•

2 replies

dotdotdot

Improve performance of widgets

4️⃣v4

$leads = Lead::where('campaign_id', $this->record->id);

$new_leads_chart = Trend::query($leads)->between($curPeriod[0], $curPeriod[1])->perDay()->count()->pluck('aggregate')->all();

$old_leads = $leads->whereBetween('created_at', $prevPeriod)->count();

$leadGrowthRate = $this->calculateGrowth($old_leads, array_sum($new_leads_chart));

return Stat::make('Recent Leads', array_sum($new_leads_chart))->chart($new_leads_chart)->indication($this->indicateGrowth($leadGrowthRate, '%'));

$leads = Lead::where('campaign_id', $this->record->id);

$new_leads_chart = Trend::query($leads)->between($curPeriod[0], $curPeriod[1])->perDay()->count()->pluck('aggregate')->all();

$old_leads = $leads->whereBetween('created_at', $prevPeriod)->count();

$leadGrowthRate = $this->calculateGrowth($old_leads, array_sum($new_leads_chart));

return Stat::make('Recent Leads', array_sum($new_leads_chart))->chart($new_leads_chart)->indication($this->indicateGrowth($leadGrowthRate, '%'));

Improve performance of widgets

Similar Threads

Improve performance of widgets

Similar Threads

Similar Threads

Similar Threads