Laravel search result is too slow

Laravel search result is too slow

I need to build search functionality in my website. So far I have implemented the query in eloquent. It is like this,

I need to build search functionality in my website. So far I have implemented the query in eloquent. It is like this,

`$syukko = Syukko::where('category',  $cat)
->where('status', 1)
->get();`

Now, this website may have a large database. My tester tested it and reported that, it was performing too slow. I tried to use paginate to show 20 results per page. Still the speed was not improving.

One colleague suggested me to use AJAX. My question is does AJAX search perform faster than basic eloquent in pgsql? (live search is not necessary)

Also, currently I don't have large database with my machine. I write the code and send it to tester. Can I use any tool to get query time in localhost?

Angular 9 Tutorial: Learn to Build a CRUD Angular App Quickly

What's new in Bootstrap 5 and when Bootstrap 5 release date?

Brave, Chrome, Firefox, Opera or Edge: Which is Better and Faster?

How to Build Progressive Web Apps (PWA) using Angular 9

What is new features in Javascript ES2020 ECMAScript 2020

Ajax Pagination In Laravel 6

laravel 6 ajax pagination with jquery, laravel 6 pagination json, jquery ajax pagination in laravel 6, laravel 6 ajax bootstrap pagination, pagination jquery ajax laravel 6, laravel 6 pagination ajax,laravel 6 pagination ajax example,ajax pagination in laravel 6

Laravel 6 Ajax Request Tutorial

In this post, you'll learn how to write jquery ajax form submit in Laravel 6. We will write Jquery Ajax post request Laravel 6. We will protect csrf token with Ajax request in Laravel 6. I will give you very simple example of Laravel 6 Ajax post request tutorial.

How to image upload using Ajax in Laravel 6

In this post, you will learn how to image upload using Ajax in Laravel 6 App. I write simple tutorial of Laravel 6 Ajax image upload with validation. We will use Jquery form js for Ajax image upload in Laravel 6.