I have developed a website that needs to fetch data from a database every 2 seconds in order to display a dynamic market with changing prices and volumes.
Below is the code I am using:
$.ajax({
type: "get",
url: "getData.php",
data: {
item: 'H',
type: 'price'
},
success: function (high) {
$.ajax({
type: "get",
url: "getData.php",
data: {
item: 'L',
type: 'price'
},
success: function (low) {
var dist = high - low;
// implement functionality based on the high and low prices...
// continue fetching data based on the high and low prices...
//more ajax calls are nested within here...
}
});
}
});
Could this nested ajax call lead to excessive CPU usage on the server?
In my getData.php file, I always include require_once('connect.php'); which establishes a connection to the database. Could this be causing numerous mysql connections, as I sometimes encounter the error 'exceeded the maximum mysql connection limit'? How can I address this issue? Should I consolidate similar ajax calls and use parseJSON?
Thank you.