Database mailing/ please share.

[clip4free]

Gfy bros and sis,

I've got a question here and if someone can share,
I would very much appreciate it.

I have built quite a big of database 'opt-in' sources
for 18 mths.

I have so far used .php based newsletter program
but it seems I'm having hard time delivering than
before. Initially when I had 5 digits databases I had
no problem delievering, now my list is much 10 folds
larger than before.

Any suggestion to handle 1.6-3 million opt-in database?

Thank you in advance.

[schneemann]

What seems to be the problem? Are you having a hard time sending that many? How many are you sending at once? Or are you having a hard time storing that many?

One problem you might have is your newsletter program probably selects ALL recipients at once into a large array then loops through the result set to send them off. What happens is that the result set is stored in memory. That, undoubtedly will mean your server's memory gets overloaded. What you probably need is a system which picks only a few at a time (and keeps doing that until everyone has received it)