I am looking for any advice regarding the best practice when pulling large data from the database using PHP annd ORACLE db and calling it using an AJAX function (jQuery or React).
I have a large dataset (about ~ 2 million row) and I am required to pull at least 30% of it all the time.
The data request is called using a front-end written in simple Javascript that utilizes the AJAX function.
I'm simply just using the "traditional" way of pulling data.
No prefetching,binding queries or stored procedure. just simply parsing the data. (i.e Select * from sample_table where id='123';
Every time I tried to pull certain amounts of data. The browser crashes.