Level 88
You can improve the whereDate already
$date = Carbon::parse('Y-m-d H:i:s', $data['date']);
$query->whereDate('AcctStartTime', $date);
The query doesn't look that slow to me. You can improve a lot by adding the correct indexes.
Nov 24, 2017
3
Level 1
Improving Query
$data = TopWireless::select(DB::raw('UserName, sum(AcctInputOctets) as Input , sum(AcctOutputOctets) as Output'))
->whereDate('AcctStartTime' , 'regexp', date($data['date']))->groupBy('UserName')->orderBy('Output', 'desc')->limit(20)->get();
I'm wondering how to improve this query. This is taking too much time to complete.
Level 1
@bobbybouwmann Added a date range picker instead of a simple date picker Now i'm not having 'lag' problems haha
Level 88
Great!
Please or to participate in this conversation.