Re: Uploading a file list of emails

 
From: "Dada Mail" <dada@PROTECTED>
In-Reply-To: Re: Uploading a file list of emails
Date: October 11th 2006

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,

rss/atom
‹ Mail vom 11.10.2006
Index
Re: Uploading a file list of emails ›
  • This mailing list is a public mailing list - anyone may join or leave, at any time.
  • This mailing list is a group discussion list (unmoderated)

  • Start a new thread, email: dadadev@dadamailproject.com

This is the developer discussion mailing list for Dada Mail.

If you are just looking for support Dada Mail, consult the message boards at:

https://forum.dadamailproject.com

Documentation for Dada Mail:

https://dadamailproject.com/d

Specifically, see the Error FAQ:

https://dadamailproject.com/d/FAQ-errors.pod.html

To post to this list, send a message to:

mailto:dadadev@dadamailproject.com

All subscribers of this list may post to the list itself.

Topics that are welcome:

  • Constructive critiques on the program (I like, "x", but, "y" needs some work - here's an idea on how to make this better...)
  • Bug/Error reports
  • Bug fixes
  • Request For Comments on any changes to the program
  • Help customizing Dada Mail for your own needs
  • Patches
  • Language Translations
  • Support Documentation/Doc editing, FAQ's, etc.
  • Discussion of any changes that you would like to be committed to the next version of Dada Mail -

Dada Mail is on Github:

https://github.com/justingit/dada-mail/

If you would like to fork, branch, send over PRs, open up issues, etc.

Privacy Policy:

This Privacy Policy is for this mailing list, and this mailing list only.

Email addresses collection through this mailing list are used explicitly to work within this email discussion list.

We only collect email addresses through our Closed-Loop Opt-In system.

We don't use your email address for any other purpose.

We won't be sharing your email address with any other entity.

Unsubscription can be done at any time. Please contact us at: justin@dadamailproject.com for any help regarding your subscription, including removal from the mailing list.

All mailing list messages sent from us will include a subscription removal link, which will allow you to remove yourself from this mailing list automatically, and permanently.

All consent to use your email address for any other purpose stated at the time of the mailing list subscription will also be revoked upon mailing list removal.