Jump to content

occurence of cron job effects


dadamssg

Recommended Posts

Just to illustrate.

 

For the last 8 years I have a cron on a local unix server that runs a macro, every fifteen minutes, 365 days, to generate a "goodly" sized .psv file from an informix DB and upload it to my web server, ; my web server's cron then checks every fifteen minutes, 365 days, for the new .psv file and loads it into a mysql DB.

 

Never had a problem in the entire 8 years. The psv file is anywhere from 700k to 1.5mb - and while that's a decent sized file, it is both generated then loaded in seconds.

 

That's just one of MANY complex jobs the crons run both locally and online.

 

If a task itself take up a lot of processing time, it does so regardless of the cron automation.

 

Link to comment
Share on other sites

It all depends.  It's not the cron itself, it's the scipt and other issues.

 

It would depend on your server, how you have your DB setup, how many rows you're deleting, how optimized your code is etc...

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.