I browsed the source in order to look a bit at the queries and see what indexes could be added... I did NOT profile the code AT ALL... On 9/11/07, Dada Mail (Justin Simoni) wrote: > > I was helping a client with a slow Dada Mail and we were thinking > that the SQL table schema could do with an overhaul. Here are the > current optimized schemas - most of the changes have been to manage > the data type a bit more finely. Any one see any problems? Anyone add > any useful indexes? > > (MySQL) > ...Continue Reading

Well... FWIW, I did the checks manually (diff'ing the output of 'SELECT' vs. 'SELECT DISTINCT') and it turned out that most duplicates had to do with addresses which had uppercase characters... it seems older versions of dada allowed this, so that, if I got 'El.Baby@PROTECTED' in the database and then tried to insert 'el.baby@PROTECTED' I'd succeed ('cause now the verification process is always done in lowercase)... I simply did the following: UPDATE dada_subscribers SET email=lower(email) WHERE BINARY emai ...Continue Reading

On 9/11/07, Henry Hughes wrote: > > Mariano, > > The table that holds the email address can contain more than one list, > that the same email address may be subscribed to: I know that (in fact, I *do* have a couple of lists that have subscribers in common). > > > CREATE TABLE dada_subscribers ( > email_id int4 not null primary key auto_increment, > email text(320), > list varchar(16), > list_type varchar(64), > list_status char(1) > ); > > Therefo ...Continue Reading

Mariano, The table that holds the email address can contain more than one list, that the same email address may be subscribed to: CREATE TABLE dada_subscribers ( email_id int4 not null primary key auto_increment, email text(320), list varchar(16), list_type varchar(64), list_status char(1) ); Therefore it is very possible that at first glance you could have duplicates, but check the 'list' field too, as this is the key that differentiates between one list and another. SELECT DISTINCT(`email`) ...Continue Reading

The schemas look fine, but what are you changing in terms of content/format? I will need to know if there is breakage in the Joomla bridge and, if so, plan a coordinated release. Thanks, Bruce Dada Mail (Justin Simoni) wrote: I was helping a client with a slow Dada Mail and we were thinking that the SQL table schema could do with an overhaul. Here are the current optimized schemas - most of the changes have been to manage the data type a bit more finely. Any one see any problems? Anyone add any useful indexes? (MySQ ...Continue Reading

On 9/10/07, Mariano Absatz wrote: > Thanx a lot Justin... > > I just modified Mail::Send.pm like this (patch attached). > > Tonight I have to send a message to a large list. I'll let you know how it went. Well... the patch had a bug (my own, a classical excess of copy&paste bug)... I attach the correct one. It worked as intended, indeed. ...Continue Reading

Hi, I have a very large list (about 5k addresses) and every now I then I find an address that is duplicated... that is, there are two entries for it in the database. The only way to solve this is to erase the address and re-add it (since you can't erase only one). This is possible because the address field is not "unique" in the database (and then, if it were, it could also happen because of different capitalization). I think this shouldn't happen, but maybe the problem happened some time ago with a diffe ...Continue Reading

I was helping a client with a slow Dada Mail and we were thinking that the SQL table schema could do with an overhaul. Here are the current optimized schemas - most of the changes have been to manage the data type a bit more finely. Any one see any problems? Anyone add any useful indexes? (MySQL) CREATE TABLE dada_settings ( list varchar(16), setting varchar(64), value text ); CREATE TABLE dada_subscribers ( email_id ...Continue Reading

Hello everyone, Just a heads-up that I'll be moving my World Headquarters about 15 blocks to the North this week, starting tomorrow. I'm foreseeing problems getting the internet hooked up at the new place, so I may be offline at the WHQ for a day or so. So that's the downside. The bright side of the move is - you should see the kitchen! ...Continue Reading

Thanx a lot Justin... I just modified Mail::Send.pm like this (patch attached). Tonight I have to send a message to a large list. I'll let you know how it went. On 9/10/07, Dada Mail (Justin Simoni) wrote: > > On Sep 7, 2007, at 12:01 PM, Mariano Absatz wrote: > > > did you finally do this? can you send me a patch? or else... at least > > you have a good guess of where should I do what? > > OK, here's basically the deal. In the dada/DADA/Mail/Send.pm file, > you'll have to find the, _ma ...Continue Reading