I have table LocationStatus with 4 millions records as now, when i use this query LocationStatus::where('imei',$mhe->imei)->orderByDesc('serverDatetime')->first();
what i tried
indexing in sql
Laravel chunk
The result takes almost one minute, does anyone have any suggestions?
New contributor
maulik savaliya is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.