Query on my model taking too much time to finish.

instead of get(); do toSql() to dump out the query and post it here (and also run in mysql directly)

Slow query is usually a symptom of no indexes in your table..

also for dates you dont do ->where('AcctStartTime' , 'LIKE', $data['date'] . '%') you canuse the '=' instead..

what @shez1983 says. plus do an explain.

As in Explain select * from foo.

see if it's using indexes.

determine what's the date where clause is about. likes are expensive.

and yeah if AcctStartTime is a DateField then that's a problem.

AcctStartTime is the date, I think This is taking too much time cus i have over 50.000 entries to This table

Usually when my queries take that long it's because I'm not using indexes on the fields I am searching by. If you don't have an index on 'AcctStartTime' you should try creating one. To check what fields have indexes from tinker you can use

 DB::select('show index from table-name')

@mattsplat

   {#766
       +"Table": "radacct",
       +"Non_unique": 1,
       +"Key_name": "AcctStartTime",
       +"Seq_in_index": 1,
       +"Column_name": "AcctStartTime",
       +"Collation": "A",
       +"Cardinality": 8576707,
       +"Sub_part": null,
       +"Packed": null,
       +"Null": "",
       +"Index_type": "BTREE",
       +"Comment": "",
       +"Index_comment": "",

@mattsplat Added index to AcctStartTime and its getting a little less longer .... But not less enough

Is AcctStartTime a datetime? Like @shez1983 said you shouldn't use like with a date. The reason I believe is it requires additional conversion on every row and doesn't allow the index to work. Try using.

->whereDate('AcctStartTime' ,  $data['date'] )

or maybe

->whereBetween('AcctStartTime' ,[ $data['date'] . '00:00:00',  $data['date']. ' 23:59:59'])

@mattsplat The AcctStartTime is a date. I'm searching through my DB with just the year and the month. After reading what you both said i did the code like this:

            $data = TopFiber::select(DB::raw('UserName, sum(AcctInputOctets) as Input , sum(AcctOutputOctets) as Output'))
                    ->whereDate('AcctStartTime' , $data['date'])->groupBy('UserName')->orderBy('Output', 'desc')->limit(20)->get();

And is taking a lot of time yet

Changed it to where between and added a daterangepicker instead of datepicker