Re: RE: [PHP-DB] sending bulk emails

2001-11-02 Thread Shane Wright
Hi If he's going to do it, it should at least be done safely... - have a status field in your database table (unsent/sent/error) - update the status field after _every_ email you send. - do NOT do this in a transaction (otherwise if something dies everything is forgotten) - if the update

Re: [PHP-DB] sending bulk emails

2001-11-02 Thread Shane Wright
Hi I find that the best way to do it is with a script having a long/unlimited timeout, but limiting it to only a few hundred mails per execution in the SQL '... LIMIT 500'. IMO better this way than a short-timeout script - sending one email can sometimes take ages (long DNS lookup, slow

Re: [PHP-DB] Please help count ?

2002-04-04 Thread Shane Wright
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 you can do this... $myvar = ecplode(' ', $postcode); $firsthalf = $myvar[0]; But not everyone puts the space in there S On Thursday 04 April 2002 5:29 pm, Dave Carrera wrote: Hi All I have a variable returned by my application. For

[PHP-DB] mySQL max connections

2002-07-30 Thread Shane Wright
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi I have a database thats taking a bit of a hammering - enough so that the number of connections spirals up and out of control. max_connections was originally at the default of 100 - but rising above 50 or so meant actual throughput dropped so