For Programmers: Free Programming Magazines  


Home > Archive > PHP SQL > September 2005 > Cron to email - is it intensive on server ?









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Cron to email - is it intensive on server ?
karl davis

2005-09-03, 6:56 pm

I plan to use my online webhost to cron a database that is approx 50MB in
size and save it twice a day automatically and send it to email instead of
just to a temp folder to download via ftp.

Will this really be server intensive and possibly a hosting issue from my
provider ?

Will it use a large amount of memory for dumping/emailing ?

Regards,
Karl.


J.O. Aho

2005-09-03, 6:56 pm

karl davis wrote:
> I plan to use my online webhost to cron a database that is approx 50MB in
> size and save it twice a day automatically and send it to email instead of
> just to a temp folder to download via ftp.
>
> Will this really be server intensive and possibly a hosting issue from my
> provider ?
>
> Will it use a large amount of memory for dumping/emailing ?


If I would be in charge for the web hotel, I wouldn't allow the e-posting of
the database, would have it saved to a folder and let you sync the folder
instead, which would save a lot of traffic, as the database may not have been
changed between the times the cron job has been run.


Sending big emails (in this case 50MB+) affects the mail server negatively.


//Aho
karl davis

2005-09-04, 7:55 am

The database is a forums database and although it gets pruned regularly, it
is never the same as posts are saved to it every day.

How would you "sync" the folder, please what does that mean exactly ?

Thankyou for your reply. :-)

Regards,

Karl.


J.O. Aho

2005-09-05, 7:56 am

karl davis wrote:
> The database is a forums database and although it gets pruned regularly, it
> is never the same as posts are saved to it every day.
>
> How would you "sync" the folder, please what does that mean exactly ?


On the server, you setup a rsyncd (rsync server) and and set it up to export
your directory in question. You just use the rsync client to get a copy of the
directory.

webpage:
http://rsync.samba.org/

maillist:
https://lists.samba.org/mailman/listinfo/rsync


//Aho
Andy Hassall

2005-09-05, 7:10 pm

On Mon, 05 Sep 2005 12:38:58 +0200, "J.O. Aho" <user@example.net> wrote:

>karl davis wrote:
>
>On the server, you setup a rsyncd (rsync server) and and set it up to export
>your directory in question. You just use the rsync client to get a copy of the
>directory.
>
>webpage:
>http://rsync.samba.org/


Or if you have ssh access you don't even need an rsyncd, you can use it with
similar syntax to scp.

--
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com