Hi.i have a json file on the host that has a lot of data, for example, more than 50,000 data that is constantly growing, with fields like:

Code:
Name, surname, age, number of family members, number of boys, number of girls and more
There are two problems with working with this file:

1- How to create combined searches with the fastest method ?

If I want to give a simpler example, for example, something like this query in Access:
Code:
select * from tbl where (noemelk like '%22%'') AND (noevagozari='11') AND (tedadkhab='2') AND (gheimat >= 3) AND  (gheimat <= 1) AND (jahat='4') AND (asansor='no') AND (parking='yes') AND (address like '%aa%')
2- how display the output quickly in listview or datagrid or etc ?

My idea is to use two common methods, namely:

1- Or do it with the help of common loops such as for next,do loop and etc, which is very slow for search or show result
2- Or let's create a bank and table dynamically and put the information in it and perform the query with the help of SQL commands for each time read JSON file from host.

Does anyone have a better idea or method that has faster processing speed and better performance