Laravel-datatables: have question in performace

[webineh]

i have 100K record in users table how i can set limit for increase speed fetch data

return Datatables::of(DB::select('select * from users'))->make(true);

• Operating System
• PHP Version 7
• Laravel Version 5.5
• Laravel-Datatables Version

[Skintillion]

https://laravel.com/docs/5.6/pagination

or

https://datatables.yajrabox.com/services/basic

[webineh]

ok how i can post limit start , end in query ? from yaja ajax ??

return Datatables::of(DB::select('select * from users limit :from,:to',['from'=>0 , 'to'=>15]))->make(true);

i need from , to in query ??

[yajra]

@vahidalvandi use something like:

return Datatables::of(DB::table('users'))->make(true);

DB::select() returns collection while
DB::table() returns a query builder.

[webineh]

do it automatically fetch query with paginate before return to Datatables ??

[yajra]

@vahidalvandi yes, pagination is automatically applied.

[vahidalvandi]

do this create query builder ?

invoice::where('invoice_type','sale_in')->select('id','user_id','invoice_amount')->orderBy('id', 'desc')->get()

because if i remove get() search and order in table not Work

[yajra]

You need to remove ->orderBy('id', 'desc')->get() for order to work and create a builder. Inspect the ajax request to debug further if it fails.

[vahidalvandi]

i need order by desc !!

[yajra]

Then sorting will not work since it's fixed on id desc.

[vahidalvandi]

thank you