> -----Original Message-----
> From: Peter Scott [mailto:[EMAIL PROTECTED]]
>
> Although I don't know why you're worried about straining the
> mysql server;
I do not think that the mysql server would be in to much difficulty
(depending on the amount of columns) rather the processing in the perl
script would be a nightmare to get right. The bandwidth or SMTP server may
limit you as well. Are you worried about locking the table up for the
duration of the run. I am not 100% sure but does mysql use table locking, if
so this could cause a problem.
> if you do everything in one process that sends mail
> synchronously you've
> expended just as much (well a bit less) total resources, you've just
> remained connected to the database longer. Unless there's
> some issue with
> that, why not do it the simple way, then you don't have to
> worry about making sure you have a big enough mail spool.
You could run it in batches as Peter suggested although you could do it by
row number grouped on your primary key. You could select 2000 records every
10 minutes for processing. To avoid loading your server you could put some
sleep time in the process. I imagine there are ways of throttling your
script better than "sleep". Batch processing is a common enough task that
you may be able to find some ready made scripts on google for a similar
purpose.
Harry
*************************************************************************************
COLT Telecommunications
Registered in England No. 2452736
Registered Office: Bishopsgate Court, 4 Norton Folgate, London E1 6DQ
Tel. +44 20 7390 3900
This message is subject to and does not create or vary any contractual
relationship between COLT Telecommunications, its subsidiaries or
affiliates ("COLT") and you. Internet communications are not secure
and therefore COLT does not accept legal responsibility for the
contents of this message. Any view or opinions expressed are those of
the author. The message is intended for the addressee only and its
contents and any attached files are strictly confidential. If you have
received it in error, please telephone the number above. Thank you.
*************************************************************************************
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
