Jump to content
MakeWebGames

How much disc space/bandwidth does the minute cron take up?


LearningCoder

Recommended Posts

42

Nope sorry thats the meaning of life :D

Why would your host want to know that? Seems a bit odd. The size of your crons in kb size isnt really an issue. Never will be. Bandwidth doubt it either. Now cpu wise possible however I doubt that even with a minute cron as long as your queries are optimized.

Link to comment
Share on other sites

That's a question ... how do you optimize a query? Do you mean specifying the field you want as opposed to using the asterisk to pull your data? How do you know when it is optimized? What steps can you take to optimize them?

One thing that I have been doing is reducing the size of my users table. I think it has helped.

Link to comment
Share on other sites

Your on the right thought train there.

Indeed its common place to see select * from a table with far too many columns and your only checking to see if the hospital is 1 or more!!

However it goes way beyond the PHP side of it. Your mysql database should be made correctly. Reducing the overhead from badly designed tables.

MyTop and MySQL Tuner are pretty informative tools. Even a simple regular optimization of your database can make a massive difference!

Link to comment
Share on other sites

and what SRB said will go a long way to improving how your site runs.

For me it even comes down to MySQL itself.

There is a cPanel video out there somewhere which is quite good for setting up MySQL shows how badly the default install is!!

Then its your webhost. Who if on shared hosting to appease everyone installs every PHP module possible.

Personally first thing you should do. Uninstall MySQL and install either MariaDB or Percona.

Link to comment
Share on other sites

As long as your crons are being run locally and not by some 3rd party external thing they won't use any bandwidth. And their size is near nothing as all it does is run a few queries and maybe check to make sure it is actually supposed to run.

Link to comment
Share on other sites

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.   Paste as plain text instead

  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...