I am a Delphi programmer and I know that the clientdataset creates temporary tables with different functions so that I do not have to consult the database server for each filter I made.
I searched how to do the same in php, that is, if we do an incremental search, for each letter a query would be made which is a burden for the php server and Mysql.
Then: can you have the data locally, on the client machine, and then filter?
On the other hand, if you leave the page, can you not perform the general selection of all the records again?