How to solve the Timeout Error?

We have a web application in which we are fetching 100 records at a time from Supabase.

But after the number of records in the Supabase table goes over 135,000 count we have started getting Timeout Error.

In the web app we are accessing Supabase data using API as we cannot filter data using LIKE/ILIKE on multiple columns in Firebase.

In the same way we have to count the number of rows returned by search based on various sub criteria as per the value in permit_satus.

For example if the user has searched for the word drive we need to first call the API to fetch and load the result in DataTable.

Then we have to count the number of rows returned for various permit_status. For this we have to run 8 more queries to get the count for various permit_status.

Can you help me identify the bottleneck and element the timeout error?

BTW the data that we are currently using is just a fraction of the original data which is huge.

Please help solve this problem.