search

Power-Components / livewire-powergrid

⚡ PowerGrid generates modern, powerful and easy-to-customize data tables using Laravel Livewire.
https://livewire-powergrid.com
MIT License
1.41k stars 205 forks source link

Improve performance on search #1528

Closed luanfreitasdev closed 2 months ago

luanfreitasdev commented 2 months ago

Motivation

Description

This PR removes unnecessary queries when we are searching for some text. The queries executed were to get the column type to check the JSON type column and not break when using PGSQL, however, this made Powergrid a little slow. The best solution found was to cache the column name and type

Before

1

After

2

Related Issue(s): #_____.

Documentation

This PR requires Documentation update?