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

[LearningCoder]

How much disc space/bandwidth does the minute cron take up? Or all the crons, as my host it asking me.

Edited April 24, 2012 by LearningCoder

[Dominion]

Unless I'm mistaken you're using Grpg?

In any case it's doubtful anyone is just going to pluck numbers out of the air for you.

[LearningCoder]

I know but I might buy mccode instead and use it but I need to know how much disk space they take up as I may need a new host

[newttster]

Out of the box with no modifications done to them ... the actual file size for all 4 of them is 11 kb. Bandwidth to run them ... no idea.

[LearningCoder]

Ok thank you

[rulerofzu]

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.

[newttster]

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.

[rulerofzu]

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!

[newttster]

@ Ruler ...By that do you mean ... if you know for a fact that the int that you will have will only be say the number 12 you would use tinyint(2) ... that kind of thing?

@ SRB ... I'm not sure what you mean by indices???

[rulerofzu]

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.

[Lithium]

@ Ruler ...By that do you mean ... if you know for a fact that the int that you will have will only be say the number 12 you would use tinyint(2) ... that kind of thing?

@ SRB ... I'm not sure what you mean by indices???

I think he meant indexes :)

[JakeB]

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.

[LearningCoder]

Ahhhh ok thanks for your help :)

[Lithium]

http://www.thefreedictionary.com/index

Feel free to correct yourself.

While yours is also correct, I never meant to say that at all, since my way is correct also.

n. pl. in·dex·es or in·di·ces

Thx for the tip :P yet i know both are correct, in my native language you can also use both! :)