如何在api中处理sql的大量数据

Question

I need to know i created a simple api in php to fetch data from sql database. But the data is very huge. It will take so much time to get data in api(20minutes). Is their any way i need the data fastly.

I m creating api using it in angular application by http request.

Is their any other way to get data fast ?

Answer 1

If you did pagination and still your data are huge, there are other ways to make it faster.

1- Gzip compression 2- Streaming 3- Multipart JSON 4- Chunk data transferring (a kind of streaming)