CODEWITHSUNDEEP
phpmysqltclwamp
Vidya
Vidya

Reputation: 8197

Slow response to database write from php

I have my PHP scripts running on the WAMP server. Here's what i am doing

  1. PHP script A that queries the database and gets a set of rows (I have set the set_time_limit (0) // unlimited time for the script to execute )
  2. Based on the result set I execute a tcl script for each row of the result set
  3. The TCL script takes about a minute to execute , it also inserts some data to the same database
  4. Now simultaneously when the TCL script is executing , if i execute another PHP script that writes in to the database , I am not able to do it as the response time is too slow. It infact waits for the PHP script A/TCL script to complete
  5. However during this time, reads from the database is fine and quick

Does anyone has any suggestions ?

Regards, Mithun

Upvotes: 1

Views: 752

Answers (1)

Havenard
Havenard

Reputation: 27844

A Session cannot be shared by concurrent scripts. Any new requests which try to session_start() will hang at this point waiting for the previous script end.

As your script is taking undetermined time to end, its a good idea to session_write_close() right after obtaining all information it needs from the $_SESSION superglobal, so concurrent requests won't hang anymore.

Upvotes: 4

Related Questions