Yes,

for now I will make a small script that will handle my bunch of emails very quickly as they are in the format one mail in one line and I have already make the check for the validity of the emails I will insert it as a plug-in that after a few checks simply will copy the file submitted in the $FILES directory and name it with the extensions list and the name of the shortmailinglist

Ciao Davide

On 10 Oct 2006 02:23:31 -0000, Dada Mail (Justin Simoni) dada@PROTECTED wrote: I guess the answer to query the SQL table to see if a list of email addresses are subscribed to a list is something like:

    SELECT email in subscribers where email = '

user1@example com' or 'user2@example com';

And just keep "or"ing for thousands of addresses

I'm no sql wizard, but maybe: SELECT email FROM subscribers WHERE email IN ('user1@example com', ' user2@example com', 'userN@example com'); is more efficient?

(Looks up "IN" in SQL book - Finds header entitled, "Avoiding OR", when looking in the index for, "IN")

Yes! You seem to be on the right track ;)

I'll play around with that soon enough

Ok, benchmarked some tests - in Postgres at least, there's no real difference between the way it's being done and using just one query that uses, "IN" Browsing a bit online, looks like in Postgres "IN" statements are changed to a list of, "OR" statements anyways I'm also a little worried about feed the SQL server a huge query with thousands of addresses, it may just choke

So, I'm going to hold off implementing anything different for now I think the solution is to just bunch the addresses up in smaller bits - perhaps as small as 100, so not to get a browser timeout For now, I guess a workaround is to use the command line script I just posted

Cheers,

-- Justin Simoni

: Dada Mail "Write Once - Distribute Everywhere" Email Communication Software

url: http://mojo skazat com aolim: leaddadaist

On Oct 10, 2006, at 7:38 PM, Dada Mail ((Justin Simoni)) wrote:

On Oct 10, 2006, at 7:20 PM, Mariano Absatz wrote:

--

Post: dadadev@PROTECTED

Unsubscribe: http://mojo skazat com/cgi-bin/dada/mail cgi/u/dadadev/

List Information:

Archive:

On 10 Oct 2006 02:23:31 -0000, Dada Mail (Justin Simoni) dada@PROTECTED wrote: I guess the answer to query the SQL table to see if a list of email addresses are subscribed to a list is something like:

    SELECT email in subscribers where email = '

user1@example com' or 'user2@example com';

And just keep "or"ing for thousands of addresses

I'm no sql wizard, but maybe: SELECT email FROM subscribers WHERE email IN ('user1@example com', ' user2@example com', 'userN@example com'); is more efficient?

(Looks up "IN" in SQL book - Finds header entitled, "Avoiding OR", when looking in the index for, "IN")

Yes! You seem to be on the right track ;)

I'll play around with that soon enough

-- Justin Simoni

: Dada Mail "Write Once - Distribute Everywhere" Email Communication Software

url: http://mojo skazat com aolim: leaddadaist

On Oct 10, 2006, at 7:20 PM, Mariano Absatz wrote:

On 10 Oct 2006 02:23:31 -0000, Dada Mail (Justin Simoni) dada@skazat com wrote:

The other problem is that it just takes a long time to sort the email addresses into ones that are valid, not subscribed, invalid, subscribed, blacklisted, etc For the PlainText backend, I don't know what kind of optimization I can do There's probably more room for optimization on the SQL backend, but my SQL-foo currently isn't the best - although I may get around to it soon Currently, there's at least - at the very least, one SQL statement per email address you're attempting to subscribe - if you have a list of 5,000, that's 5,000 SQL statements run - which isn't optimized at all I guess the answer to query the SQL table to see if a list of email addresses are subscribed to a list is something like:

    SELECT email in subscribers where email = '

user1@example com' or 'user2@example com';

And just keep "or"ing for thousands of addresses

I'm no sql wizard, but maybe: SELECT email FROM subscribers WHERE email IN ('user1@example com', ' user2@example com', 'userN@example com'); is more efficient?

-- Mariano Absatz - El Baby el (dot) baby (AT) gmail (dot) com el (punto) baby (ARROBA:@) gmail (punto) com Post: mailto:dadadev@skazat com

Unsubscribe: http://mojo skazat com/cgi-bin/dada/mail cgi/u/dadadev/

List Information: http://mojo skazat com/cgi-bin/dada/mail cgi/list/dadadev

Archive: http://mojo skazat com/cgi-bin/dada/mail cgi/archive/dadadev

--

Post: dadadev@skazat com

Unsubscribe: http://mojo skazat com/cgi-bin/dada/mail cgi/u/dadadev/

List Information:

Archive: