Laravel Server Side Yajra DataTable - Load Large Data Within Few Seconds

 

Large Data or 1 million Data Quick Load within few seconds in Laravel Server Side DataTables 

• Run the following in the command/terminal to create a new laravel project,
  
  1	composer create-project laravel/laravel yajra-table-large-data-handle

• Run the following in the command/terminal to install yajra datatables package,
  
  1	composer require yajra/laravel-datatables-oracle

• Check composer.json
  
  1 2 3 4

  "require": { ………………         "yajra/laravel-datatables-oracle": "~9.0" },

   
• Add the following code file to config/app.php

1 2 3 4 5 6 7 8 9

'providers' => [     ...,     Yajra\DataTables\DataTablesServiceProvider::class, ]   'aliases' => [     ...,     'DataTables' => Yajra\DataTables\Facades\DataTables::class, ]

• publish the configuration, run the following line in the terminal,
  
  1	php artisan vendor:publish

• in .env for database setup
1 2 3 4 5 6

DB_CONNECTION=mysql DB_HOST=127.0.0.1 DB_PORT=3306 DB_DATABASE=database_name DB_USERNAME=root DB_PASSWORD=

• Add below files for list details in the table

or you can click the link to clone the project https://github.com/rajadavid423/yajra-table-large-data-handle.git

• Finally, download the below SQL file to import into the database
  
  1 million data SQL file - https://drive.google.com/file/d/1PGvg5hWaQRjEA78iPABpOhYIiwbtS1_w/view?usp=sharing

     5 lakhs data SQL file - https://drive.google.com/file/d/1IhsdWS4OSNLZB64QsQsHIYa00hF9kywu/view

Note:

Example: