Too Many TCP Connections to Database

Discussion and feedback on Construct 2

Post » Wed Jan 28, 2015 2:07 am

While tracing my ajax connections to the database through chrome, I've found that I have made between 200-500 connections.

I've included a screen shot showing the tons of connections.

I just do an Ajax "Request URL" and Ajax "On Complete" then load the last data into an array
"http://192.168.1.83:7890/rr55.php"
followed by
set value tokenat(AJAX.LastData,EachX,"|")

When I start the game I can load many rows of data rows into my array.
However when I process the rows of data and request more rows, I find I'm having problems with nothing returning from the requests.

Is this an option somewhere?

Perry
You do not have the required permissions to view the files attached to this post.
B
13
S
3
G
1
Posts: 9
Reputation: 831

Post » Mon Feb 09, 2015 2:22 am

Issue was resolved. While waiting for data to return I made far too many additional calls to my database, further down in my code. Once I fixed the logic, the correct data in the proper sequences was returned. I was also able to reduce the number of connects by reducing the number of child processes on my web server.
B
13
S
3
G
1
Posts: 9
Reputation: 831


Return to Construct 2 General

Who is online

Users browsing this forum: LaDestitute and 38 guests