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?

laravel ajax postgresql

Bootstrap 5 Complete Course with Examples

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

Building a simple Applications with Vue 3

Deno Crash Course: Explore Deno and Create a full REST API with Deno

How to Build a Real-time Chat App with Deno and WebSockets

Convert HTML to Markdown Online

HTML entity encoder decoder Online

Php how to delete multiple rows through checkbox using ajax in laravel

In this article i will let you know to delete multiple rows through checkbox using ajax in laravel and before delete we will give a confirmation message.

Select2 Ajax Autocomplete in Laravel

select2 ajax json example laravel framework, laravel select2 tags, laravel select2 tables ajax, laravel dynamic autocomplete jquery ajax example, laravel autocomplete from database, laravel autocomplete select2

Laravel 7 Ajax Example Tutorial: How to Use Ajax in Laravel

In this Laravel 7 AJAX tutorial, we will learn how to create a Laravel CRUD app using AJAX. The central idea of this tutorial is to create a simple app that can create and fetch todo items in sync with MySQL database. Laravel AJAX Example AJAX is primarily used to make flawless HTTP requests to […]

Laravel 7 Ajax CRUD Example Tutorial From Scratch

Laravel 7, 6 ajax crud example tutorial. In this tutorial, you will learn how to create laravel ajax crud application with a bootstrap popup modals.

Laravel, jQuery Ajax Categories and Subcategories, Select Dropdown

Laravel 7 dynamic dependent dropdown using ajax, you will learn how to show selected subcategories dependent on selected category dropdown using jquery ajax.