There is a MySQL database table include Persons records and they filled once and then they will not changes later, but will be used several times in various type for preview and most important issue is that they are more than 1000 records and will showing as paging in various sort of Name, LName, Address, Code etc. Also they will use in search form and the search form has filter option.
Due to the above description and the unnecessary features which is in database (MySQL) (i.e. connection, insert, edit) advise me alternative source which I can create it from database after each changing data and then using it for preview and search. I was thinking about text file as json format but it's not good idea because it will use RAM and cpu to be prepared. if it's important so language is PHP.
So:
I need an alternative to create a source file from one big MySQL database table records which will use as read-only but include sort, search, filter option and without inserting, modifying, connection feature.
