Databases
StackOverflow2013
Postsdbo
POWhy is it so bad to run a PHP script continuously?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POWhy is it so bad to run a PHP script continuously?
    primarykey
    data
    text
    <p>I have a map. On this map I want to show live data collected from several tables, some of which have astounding amounts of rows. Needless to say, fetching this information takes a <em>long</em> time. Also, pinging is involved. Depending on servers being offline or far away, the collection of this data could vary from 1 to 10 minutes.</p> <p>I want the map to be snappy and responsive, so I've decided to add a new table to my database containing only the data the map needs. That means I need a background process to update the information in my new table continuously. Cron jobs are of course a possibility, but I want the refreshing of data to happen as soon as the previous interval has completed. And what if the number of offline IP addresses suddenly spike and the loop takes longer to run than the interval of the Cron job?</p> <p>My own solution is to create an infinite loop in PHP that runs by the command line. This loop would refresh the data for the map into MySQL as well as record other useful data such as loop time and failed attempts at pings etc, then restart after a short pause (a few seconds).</p> <p>However - I'm being repeatedly told by people that a PHP script running for ever is BAD. After a while it will hog gigabytes of RAM (and other terrible things)</p> <p>Partly I'm writing this question to confirm if this is in fact the case, but some tips and tricks on how I would go about writing a clean loop that doesn't leak memory (If that is possible) wouldn't go amiss. Opinions on the matter would also be appreciated.</p> <p>The reply I feel sheds the most light on the issue I will mark as correct.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USJohn Parker
    1. USHubro
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POWhy is it so bad to run a PHP script continuously?
      1. USKingCrunch
      1. VTFavorite
    2. VO
      singulars
      1. POWhy is it so bad to run a PHP script continuously?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POWhy is it so bad to run a PHP script continuously?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COAn incredibly minor point, but please don't add signatures/sign-offs to questions. (That aside, this is a very well constructed question.) :-)
      singulars
      1. POWhy is it so bad to run a PHP script continuously?
      1. USJohn Parker
    2. COSorry and thanks :-)
      singulars
      1. POWhy is it so bad to run a PHP script continuously?
      1. USHubro
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload